（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

答案：（B、C）

解析：

参考V$RSRC_CONSUMER_GROUP视图

CPU_WAIT_TIME, 因为资源管理器，会话等待CPU的累积时间，不包括因为latch、入队竞争、I/O等待，等的等待时间

ITPub博客

Oracle 11G OCP 1Z0-053 20

最新文章