nerdexam
Oracle

1Z0-062 · Question #159

Examine the resources consumed by a database instance whose current Resource Manager plan is displayed. Which two statements are true?

The correct answer is C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group E. A user belonging to the DSS__QUERIES resource consumer group can create a new session but. In Oracle Resource Manager, CPU_WAIT_TIME records cumulative time sessions waited for CPU, and a user in a consumer group can still create sessions until the group's configured limit is reached.

Managing Performance

Question

Examine the resources consumed by a database instance whose current Resource Manager plan is displayed. Which two statements are true?

Options

  • AAn attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
  • BAn attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.
  • CThe CPU_WAIT_TIME column indicates the total time that sessions in the consumer group
  • DThe CPU_WAIT_TIME column indicates the total time that sessions in the consumer group
  • EA user belonging to the DSS__QUERIES resource consumer group can create a new session but

How the community answered

(22 responses)
  • A
    14% (3)
  • B
    5% (1)
  • C
    77% (17)
  • D
    5% (1)

Why each option

In Oracle Resource Manager, CPU_WAIT_TIME records cumulative time sessions waited for CPU, and a user in a consumer group can still create sessions until the group's configured limit is reached.

AAn attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.

New sessions from DSS_QUERIES users are rejected only when the group's configured maximum active session limit is exhausted, not simply because a Resource Manager plan is active.

BAn attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.

OTHER_GROUPS is a catch-all consumer group for unmapped users and is not typically configured to reject new sessions with an error.

CThe CPU_WAIT_TIME column indicates the total time that sessions in the consumer groupCorrect

The CPU_WAIT_TIME column in V$RSRC_CONSUMER_GROUP accumulates the total time (in centiseconds) that sessions in the consumer group were runnable but waiting to be scheduled on the CPU by the Resource Manager.

DThe CPU_WAIT_TIME column indicates the total time that sessions in the consumer group

This choice is a duplicate or incomplete variant that does not describe a distinct or accurate behavior of the CPU_WAIT_TIME metric.

EA user belonging to the DSS__QUERIES resource consumer group can create a new session butCorrect

A user mapped to DSS_QUERIES can create a new session as long as the group's maximum session limit has not been reached - Resource Manager throttles resources rather than unconditionally blocking all new sessions.

Concept tested: Oracle Resource Manager consumer group CPU wait time and session limits

Source: https://docs.oracle.com/database/121/ADMIN/dbrm.htm

Topics

#Resource Manager#consumer groups#CPU_WAIT_TIME#session management

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-062 Practice