053-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

V$RSRC_CONSUMER_GROUP:包含所有活动组统计信息的视图
下面简要描述了此视图中的部分列:
• name:使用者组的名称。
• active_sessions:此使用者组中的当前活动会话数。
CPU_WAITS:所有会话已经等待的总时间
CONSUMED_CPU_TIME:消费组中的所有会话消耗的累积总的 CPU
QUEUE_LENGTH:在队列中等待的会话数。
CPU_WAIT_TIME:由于资源管理器,会话等待 CPU 的累积总时间。这不包括 latch 或排队争用,I/ O 等待等等。 C 正确,D 错误
由图示可以看到 DSS_QUERIES 中的 QUEUE_LENGTH 为 2,说明已经有会话等待。所以后面的会话会等待资源。 B 正确,A 错误

原文地址:https://www.cnblogs.com/Babylon/p/7844112.html