Examine the resources consumed by a database instance whose current Resource Manager
plan is displayed.
SQL> SELECT name, active_sessions, queue_length,
consumed_cpu_time, cpu_waits, cpu_wait_time
FROM v$rsrc_consumer_group;
Which two statements are true?
A.
An attempt to start a new session by a user belonging to DSS_QUERIES fails with an
error.
B.
An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an
error.
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 I/O waits and latch or enqueue contention.
E.
A user belonging to the DSS__QUERIES resource consumer group can create a new
session but the session will be queued.
C and E
Thanks Puntano!
Any link to confirm C, E anyone? Thank you!
C.
Cumulative amount of time that sessions waited for CPU because of resource management.
https://docs.oracle.com/cloud/latest/db121/REFRN/refrn30214.htm#REFRN30214
E. QUEUE_LENGTH NUMBER Number of sessions waiting in the queue
CE
CE