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 control the amount of memory allocated in SGA for the local variables for each shared
server process
B.
To limit the User Global Area (UGA) memory allocated to a session from the SGA
C.
To limit the amount of memory to be used for the dispatcher queue of a session in SGA
D.
To limit the amount of memory to be used for the request pool in System Global Area
(SGA)
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_6010.htm
PRIVATE_SGA – Specify the amount of private space a session can allocate in the shared pool of the system global area (SGA)
OR
the number of kilobytes that the session is allowed to take in the SGA for session data
B. is wrong, not sure about correct answer though, D. I guess
I’m not sure, but I think that part of the UGA is located in the shared pool… that’s why B might be correct.
I think the answer is:
B.
To limit the User Global Area (UGA) memory allocated to a session from the SGA