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
Explanation:
V$RSRC_CONSUMER_GROUP Use the V$RSRC_CONSUMER_GROUP view to monitor
resources consumed, including CPU, I/O, and parallel servers. It can also be used to monitor
statistics related to CPU resource management, runaway query management, parallel
statement queuing, and so on. All of the statistics are cumulative from the time when the
plan was activated.
SELECT name, active_sessions, queue_length,
consumed_cpu_time, cpu_waits, cpu_wait_time
FROM v$rsrc_consumer_group;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.
