Oracle 11G OCP 1Z0-053 20

(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等待,等的等待时间



请使用浏览器的分享功能分享到微信等