What could be the reason for this?

Your database is configured in shared server mode. However, your senior DBA asks you to modify the value of the PRIVATE_SGA limit in the profile of the users.
What could be the reason for this?

Your database is configured in shared server mode. However, your senior DBA asks you to modify the value of the PRIVATE_SGA limit in the profile of the users.
What could be the reason for this?

A.
To limit the User Global Area (UGA) memory allocated to a session from the SGA

B.
To control the amount of memory allocated in SGA for the local variables for each shared server process

C.
To limit the amount of memory to be used for the request pool in System Global Area (SGA)

D.
To limit the amount of memory to be used for the dispatcher queue of a session in SGA



Leave a Reply 1

Your email address will not be published. Required fields are marked *


mr_tienvu

mr_tienvu

Correct answer is A