Upgrade to Oracle Database 12c — Question 21

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?

Answer options

• A. It is enabled only if the SHARED_SERVER_SESSIONS parameter is configured.
• B. It is enabled and the UGA is located in the large pool for connections that use the shared server configuration.
• C. It is enabled only if at least five dispatchers are configured.
• D. It is enabled and all the DBA and non-DBA sessions function in shared server mode.

Correct answer: A

Explanation

The correct answer is A because the shared server configuration requires the SHARED_SERVER_SESSIONS parameter to be set for it to be enabled. Option B is incorrect as it assumes that the UGA is always in the large pool, which may not be the case. Option C is wrong because the configuration can enable shared servers without needing a specific number of dispatchers. Option D is misleading as not all sessions necessarily operate in shared server mode.