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;
NAMEACTIVE_SESSIONS QUEUE_LENGTH CONSUMED_CPU_WAITS
CPU_WAIT_TIME
———————————– ——————– ——————– ——————— —————-
OLTP__ORDER__ENTRY1029690 467
OTHES__GROUPS 0 059823664089
60425
SYS_GROUP 1 02420704 914
19540
DS.S_QUERIES4245946603004
55700
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.