nerdexam
Oracle

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.

Managing Performance

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)
  • A
    92% (22)
  • D
    4% (1)
  • E
    4% (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.

Aspecifying an idle time limit that applies to sessions that are idle and blocking other sessionsCorrect

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.

Blimiting the degree of parallelismof operations performed by user sessions in a consumer groupCorrect

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.

Cspecifying the maximum number of concurrent sessions allowed for a userCorrect

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.

Dlimiting the CPU used per database call

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.

Especifying the amount of private space a session can allocate in the shared pool of the SGA.

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

#Database Resource Manager#Resource allocation#Consumer groups#Session management

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice