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