Oracle
1Z0-060 · Question #197
Your database uses Automatic Memory Management, and has the large pool configured. You issue the following command: SQL> ALTER SYSTEM SET SHARED_SERVERS = 5; Which statement is true about the shared…
The correct answer is A. It is enabled only if the SHARED_SERVER_SESSIONS parameter is configured. https://docs.oracle.com/cd/E71588_01/HTMIG/configuring-SHARED-SERVERS- parameter.htm#HTMIG29492
New Features for Database Infrastructure and Architecture
Question
Your database uses Automatic Memory Management, and has the large pool configured. You issue the following command:
SQL> ALTER SYSTEM SET SHARED_SERVERS = 5; Which statement is true about the shared server configuration?
Options
- AIt is enabled only if the SHARED_SERVER_SESSIONS parameter is configured.
- BIt is enabled and the UGA is located in the large pool for connections that use the shared server
- CIt is enabled only if at least five dispatchers are configured.
- DIt is enabled and all the DBA and non-DBA sessions function in shared server mode.
How the community answered
(38 responses)- A74% (28)
- B5% (2)
- C8% (3)
- D13% (5)
Explanation
https://docs.oracle.com/cd/E71588_01/HTMIG/configuring-SHARED-SERVERS- parameter.htm#HTMIG29492
Topics
#shared server#SHARED_SERVERS#large pool#UGA
Community Discussion
No community discussion yet for this question.