For which three requirements would you use the Database Resource Manager?
A. specifying an idle time limit that applies to sessions that are idle and blocking other sessions
B. limiting the degree of parallelism of operations performed by user sessions in a consumer group
C. specifying the maximum number of concurrent sessions allowed for a user
D. limiting the CPU used per database call
E. specifying the amount of private space a session can allocate in the shared pool of the SGA.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
ABC is right,
https://docs.oracle.com/cd/B19306_01/server.102/b14231/dbrm.htm
A: Limit the amount of time that a session can be idle. This can be further defined to mean only sessions that are blocking other sessions.
B: Limit the degree of parallelism of any operation performed by members of a group of users
C: Create an active session pool. This pool consists of a specified maximum number of user sessions allowed to be concurrently active within a group of users. Additional sessions beyond the maximum are queued for execution, but you can specify a timeout period, after which queued jobs will terminate.
not D: not limit, is “Distribute” available processing resources by allocating percentages of CPU time to different users and applications.
I think it should be A,B,D
can someone explain why the ans is ABC