138.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 limit the amount of memory to be used for the dispatcher queue of a session in SGA
C.to limit the amount of memory to be used for the request pool in System Global Area (SGA)
D.to control the amount of memory allocated in SGA for the local variables for each shared server process
答案:A
解析:
PRIVATE_SGA
Use this clause to apply a weight to the PRIVATE_SGA resource. This limit applies only if you are using shared server architecture and allocating private space in the SGA for your session.
Limiting Memory Use for Each User Session by Setting PRIVATE_SGA
You can set the PRIVATE_SGA resource limit to restrict the memory used by each client session from the SGA. PRIVATE_SGA defines the number of bytes of memory used from the SGA by a session. However, this parameter is used rarely, because most DBAs do not limit SGA consumption on a user-by-user basis.
UGA(User Global Area)
在专用服务器模式下,进程和会话是一对一的关系,UGA被包含在PGA中,
在共享服务器模式下,进程和会话是一对多的关系,UGA在大池(Large Pool)中分配。
如果分配失败,如大型池太小,或是根本没有设置大型池,则从共享池(Shared Pool)中分配
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 limit the amount of memory to be used for the dispatcher queue of a session in SGA
C.to limit the amount of memory to be used for the request pool in System Global Area (SGA)
D.to control the amount of memory allocated in SGA for the local variables for each shared server process
答案:A
解析:
PRIVATE_SGA
Use this clause to apply a weight to the PRIVATE_SGA resource. This limit applies only if you are using shared server architecture and allocating private space in the SGA for your session.
Limiting Memory Use for Each User Session by Setting PRIVATE_SGA
You can set the PRIVATE_SGA resource limit to restrict the memory used by each client session from the SGA. PRIVATE_SGA defines the number of bytes of memory used from the SGA by a session. However, this parameter is used rarely, because most DBAs do not limit SGA consumption on a user-by-user basis.
UGA(User Global Area)
在专用服务器模式下,进程和会话是一对一的关系,UGA被包含在PGA中,
在共享服务器模式下,进程和会话是一对多的关系,UGA在大池(Large Pool)中分配。
如果分配失败,如大型池太小,或是根本没有设置大型池,则从共享池(Shared Pool)中分配