MAXSHAREDSERVERS parameter - Definition,Features - Managing Oracle Database Processes

Q.  Which parameter specifies the maximum number of shared servers that can be automatically created by PMON?
- Published on 29 Jul 15

a. MAX_DISPATCHERS
b. MAX_SHARED_SERVERS
c. SHARED_SERVER_SESSIONS
d. SHARED_SERVERS

ANSWER: MAX_SHARED_SERVERS
 

    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


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)