Which two statements are true?

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?

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *