OCP 1Z0 053 20

20.View the Exhibit and examine the resource consumption details for the current plan in use by the 
database instance. 
Which two statements are true based on the output? (Choose two.) 
Exhibit: 

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 latch or enqueue contention 
Answer: BC 

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

V$RSRC_CONSUMER_GROUP Use the V$RSRC_CONSUMER_GROUP view to monitor CPU usage and CPU waits. It provides the 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;

NAME               ACTIVE_SESSIONS QUEUE_LENGTH CONSUMED_CPU_TIME  CPU_WAITS CPU_WAIT_TIME
------------------ --------------- ------------ ----------------- ---------- -------------
OLTP_ORDER_ENTRY                 1            0             29690        467          6709
OTHER_GROUPS                     0            0           5982366       4089         60425
SYS_GROUP                        1            0           2420704        914         19540
DSS_QUERIES                      4            2           4594660       3004         55700

In the preceding query results, the DSS_ QUERIES consumer group has four sessions in its active session pool and two more sessions queued for activation.

A key measure in this view is CPU_WAIT_TIME. This indicates the total time that sessions in the consumer group waited for CPU because of resource management. Not included in this measure are waits due to latch or enqueue contention, I/O waits, and so on.