MAXSHAREDSERVERS parameter - Definition,Features - Managing Oracle Database Processes

Discussion

• Nirja Shah   -Posted on 23 Sep 15
  - The following initialization parameters control shared server operation:
  
  - SHARED_SERVERS - Specifies the initial number of shared servers to start and the minimum number of shared servers to keep. This is the only required parameter for using shared servers.
  
  - MAX_SHARED_SERVERS - Specifies the maximum number of shared servers that can run simultaneously. The MAX_SHARED_SERVERS parameter specifies the maximum number of shared servers that can be automatically created by PMON
  
  - SHARED_SERVER_SESSIONS - Specifies the total number of shared server user sessions that can run simultaneously. Setting this parameter enables you to reserve user sessions for dedicated servers.
  
  - MAX_DISPATCHERS - Specifies the maximum number of dispatcher processes that can run simultaneously. This parameter can be ignored for now. It will only be useful in a future release when the number of dispatchers is auto-tuned according to the number of concurrent connections.

➨ Post your comment / Share knowledge