91 View the Exhibit and examine the resource consumption details for the current plan in use by the

最新推荐文章于 2018-06-22 08:22:42 发布

EVISWANG

最新推荐文章于 2018-06-22 08:22:42 发布

阅读量938

点赞数

CC 4.0 BY-SA版权

分类专栏： OCP 053

本文链接：https://blog.youkuaiyun.com/EVISWANG/article/details/50057799

OCP 053 专栏收录该内容

86 篇文章

订阅专栏

本文探讨了数据库实例中当前使用的资源计划细节，特别是针对DSS_QUERIES用户组的行为进行了分析。文章解释了当达到资源使用限制时，属于该用户组的新会话登录行为及其排队情况，并介绍了如何通过V$RSRC_CONSUMER_GROUP视图来监控CPU使用和等待时间。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

QUESTION 91
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.)
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

Correct Answer: BC
Section: (none)
Explanation

Explanation/Reference:
Explanation:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/dbrm009.htm
V$RSRC_CONSUMER_GROUP
Use the V$RSRC_CONSUMER_GROUP view to monitor CPU usage and CPU waits. It provides the
cumulative amount of CPU time consumed, cumulative amount of time waiting for CPU, and cumulative
number of CPU waits by all sessions in each consumer group. It also provides a number of other
measures helpful for tuning.
SQL> SELECT name, active_sessions, queue_length,
consumed_cpu_time, cpu_waits, cpu_wait_time
FROM v$rsrc_consumer_group;