For which two requirements would you use the Database Resource Manager?
A.
limiting the CPU used per database call
B.
specifying the maximum number of concurrent sessions allowed for a user
C.
specifying the amount of private space a session can allocate in the shared pool of the
SGA
D.
limiting the degree of parallelism of operations performed by a user or group of users
E.
specifying an idle time limit that applies to sessions that are idle and blocking other
sessions
For me D and E are the right answers. B also close
http://docs.oracle.com/cd/B28359_01/server.111/b28310/dbrm001.htm
With the Resource Manager, you can:
Guarantee certain sessions a minimum amount of processing resources regardless of the load on the system and the number of users.
Distribute available processing resources by allocating percentages of CPU time to different users and applications. In a data warehouse, a higher percentage can be given to ROLAP (relational online analytical processing) applications than to batch jobs.
Limit the degree of parallelism of any operation performed by members of a group of users. -D
Create an active session pool. An active session 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. The active session pool limits the total number of sessions actively competing for resources, thereby enabling active sessions to make faster progress. – B ?
Manage runaway sessions or calls by detecting when they consume more than a specified amount of CPU or I/O. Such sessions can be automatically terminated or switched into a different (lower priority) group.
Prevent the execution of operations that the optimizer estimates will run for a longer time than a specified limit.
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. – E
Configure an instance to use a particular scheme for allocating resources. You can dynamically change the scheme, for example, from a daytime scheme to a nighttime scheme, without having to shut down and restart the instance. You can also schedule a scheme change with Oracle Scheduler
DE
Not B since it can limit concurrent sessions among a group of users (can the group be one?).
D, E. Thanks Vonpire!
Limit the degree of parallelism of any operation performed by members of a group of users. -D
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. – E
DE