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
Answer: BC
参考：http://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_2157.htm#REFRN30214
V$RSRC_CONSUMER_GROUP视图包含所有活动组的统计信息。
Name：使用者组的名称；
Active_Sessions：此使用者组中的当前活动会话数；
Execution_Waits：等待时间片断的活动会话数；
Reuqests：使用者组中累计执行的请求数；
Queue_Length：队列中等待的会话数；
CPU_Wait_Time：会话等待CPU的累计时间，这不包括锁或排除争用，I/O等待等等；
Consumed_CPU_Time：所有会话累计消耗的CPU时间。
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
Answer: BC
参考：http://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_2157.htm#REFRN30214
V$RSRC_CONSUMER_GROUP视图包含所有活动组的统计信息。
Name：使用者组的名称；
Active_Sessions：此使用者组中的当前活动会话数；
Execution_Waits：等待时间片断的活动会话数；
Reuqests：使用者组中累计执行的请求数；
Queue_Length：队列中等待的会话数；
CPU_Wait_Time：会话等待CPU的累计时间，这不包括锁或排除争用，I/O等待等等；
Consumed_CPU_Time：所有会话累计消耗的CPU时间。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2119530/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
1Z0-053 V13.02 Q613
下一篇：
1Z0-053 V13.02 Q92
请登录后发表评论
登录
全部评论
