OCP-1Z0-053-200题-106题-20

QUESTION 106

View the Exhibit and examine the resource consumptiondetails for the current plan in use by the database

instance.

Which two statements are true based on the output? (Choose two.)

A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an error

B. A user belonging to DSS_QUERIES can log in to a new session but the session will be queued

C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the

CPU due to resource management

D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the

CPU due to resource management, I/O waits, and latchor enqueue contention

Answer: BC

同20题：http://blog.csdn.net/rlhua/article/details/13094993

Explanation/Reference:

Section: SQL, PL/SQL, Packages, Functions, Jobs & Views

http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/dbrm009.htm

V$RSRC_CONSUMER_GROUP

Use the V$RSRC_CONSUMER_GROUPview to monitor CPU usage and CPU waits. It providesthe cumulative

amount of CPU time consumed, cumulative amount of time waiting for CPU, and cumulative number of CPU

waits by all sessions in each consumer group. It also provides a number of other measures helpful for tuning.

SQL> SELECT name, active_sessions, queue_length,

consumed_cpu_time, cpu_waits, cpu_wait_time

FROM v$rsrc_consumer_group;