OCP-1Z0-053-V12.02-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

Answer: BC 

答案解析:

参考:http://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_2157.htm#REFRN30214


V$RSRC_CONSUMER_GROUP:包含所有活动组统计信息的视图

下面简要描述了此视图中的部分列:
• name:使用者组的名称。
• active_sessions:此使用者组中的当前活动会话数。
• execution_waiters:等待时间片断的活动会话数。
• requests:此使用者组中累计执行的请求数。
QUEUE_LENGTH: Number of sessions waiting in the queue: 在队列中等待的会话数。
CPU_WAIT_TIME: Cumulative amount of time that sessions waited for CPU because of resource management. This does not include waits due to latch or enqueue contention, I/O waits, and so on.:因为资源理,会话等待CPU累积大量时间。这不包括锁存或排队争用,I/ O等待等等。
会话等待CPU 的累计时间。
• consumed_cpu_time:所有会话累计消耗的CPU 时间。

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值