1Z0-062 · Question #266
For which three requirements would you use the Database Resource Manager?
The correct answer is A. specifying an idle time limit that applies to sessions that are idle and blocking other sessions B. limiting the degree of parallelismof operations performed by user sessions in a consumer group C. specifying the maximum number of concurrent sessions allowed for a user. Oracle Database Resource Manager (DBRM) is used to control various aspects of session resource consumption, including idle time limits for blocking sessions, degree of parallelism for consumer groups, and maximum concurrent sessions per user.
Question
For which three requirements would you use the Database Resource Manager?
Options
- Aspecifying an idle time limit that applies to sessions that are idle and blocking other sessions
- Blimiting the degree of parallelismof operations performed by user sessions in a consumer group
- Cspecifying the maximum number of concurrent sessions allowed for a user
- Dlimiting the CPU used per database call
- Especifying the amount of private space a session can allocate in the shared pool of the SGA.
How the community answered
(24 responses)- A92% (22)
- D4% (1)
- E4% (1)
Why each option
Oracle Database Resource Manager (DBRM) is used to control various aspects of session resource consumption, including idle time limits for blocking sessions, degree of parallelism for consumer groups, and maximum concurrent sessions per user.
Database Resource Manager allows specifying an `IDLE_TIME` limit for consumer groups, which can be configured to detect and terminate sessions that are idle and actively blocking other sessions, thereby preventing resource contention.
DBRM enables administrators to limit the degree of parallelism for operations performed by user sessions belonging to a specific consumer group, ensuring that parallel execution does not excessively consume system resources.
Resource Manager plans can include directives that specify the maximum number of concurrent sessions allowed for a particular user or consumer group, helping to prevent resource exhaustion from an excessive number of active connections.
While Database Resource Manager can limit CPU usage, it typically does so by allocating CPU percentages or absolute limits over time to consumer groups, rather than directly by 'limiting the CPU used per database call' at such a granular level.
The amount of private space a session allocates in the shared pool, specifically within the Private SQL Area, is primarily managed by initialization parameters related to PGA and memory management (e.g., `PGA_AGGREGATE_TARGET`), not directly by the Database Resource Manager.
Concept tested: Oracle Database Resource Manager features
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-resources-with-oracle-database-resource-manager.html#GUID-E5B09572-A274-429C-A20D-1B124C286D24
Topics
Community Discussion
No community discussion yet for this question.