OCP-1Z0-053-V12.02-20题

AI权益加码!Claude Code、Cursor等20+工具免费用! 购周边限时加赠Coding Plan Lite,畅享主流AI工具!学习进阶更高效! 阅读详情

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 时间。

ORACLE-OCP-071考试目和答案附带解析 立即下载

相关推荐

OCP 1Z0-0531~30

1.While deploying a new application module,the software vendor ships the application software along w...

coco3600的博客 3220

OCP-1Z0-053-200-106-20

QUESTION 106 View the Exhibit and examine the resource consumptiondetails for the current plan in use by the database instance. Which two statements are true based on the output? (Choose two.) A

一抹曦阳-Oracle 3636

Oracle 053 668-728译文版

QUESTION NO:668 Examine the output ofthe query that you executed to list the objects in the recycle bin:   You verified that notable named SALES_TAB exists in the schema. Then you executed the f

Jesse的黑洞 3912

166.View the Exhibit and examine the structures of the EMPLOYEES and DEPARTMENTS tables.

166.View the Exhibit and examine the structures of the EMPLOYEES and DEPARTMENTS tables.

dwj19830118的专栏 1837

OCP-1Z0-053-V13.02-702

702. View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE). When you tried to start the database instance, you received the following error:   Why di

一抹曦阳-Oracle 9513

OCP-1Z0-053-V12 02-20

OCP-1Z0-053-V12 02-20

sdfsdkk的博客 140

OCP-1Z0-053-V12.02-501

501.Note the output of the following query; SQL> SELECT flashback_archieve_name, status FROM dba_flashback_archieve; 此处表名有点错误,应该为DBA_FLASHBACK_ARCHIVE FLASHBACK_ARCHIEVE_NAME STATUS FLA1 You execu

一抹曦阳-Oracle 1万+

OCP 11G 053库解析汇总链接(201-400)

racle OCP 11G 053201-400)答案解析目录

u011443258的博客 131

OCP-1Z0-053-V12.02-185

185.A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger, which command would you use to back up

一抹曦阳-Oracle 7656

OCP-1Z0-053-V12.02-115

115.What are the advantages of variable extent size support for large ASM files? (Choose two.) A. It improves resync operations when the disk comes online after being taken offline for maintenance pu

一抹曦阳-Oracle 8431

OCP-1Z0-053-V12.02-446

446.Consider the following code snippet: BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE ( name => ,,lne_job1, attribute => ,,job_priority, value => 1); END; / If this code were executed, which of the foll

一抹曦阳-Oracle 4567

OCP-1Z0-053-V12.02-510

510.You executed the following command in Recovery Manager (RMAN): RMAN> REPORT NEED BACKUP days 3; What is the output of this command? A. a list of files that require a backup within three days B

一抹曦阳-Oracle 1万+

OCP-1Z0-053-V12.02-96

96.Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed? A. The shrink operation touches every block in t

一抹曦阳-Oracle 1万+

OCP-1Z0-053-V12.02-156

156.What is the effect of increasing the value of the ASM_POWER_LIMIT parameter? A. The number of DBWR processes increases B. The number of ASMB processes increases C. The number of DBWR_TO_SLAVES

一抹曦阳-Oracle 6611

OCP-1Z0-053-V12.02-22

22.An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command: SQL>CREATE INDEX ord_custname_ix ON orders(custname); The ORDERS table is

一抹曦阳-Oracle 7096

OCP-1Z0-053-V12.02-464

464.Which of the following are valid settings for the NLS_COMP parameter? (Choose all that apply.) A. ASCII B. ANSI C. BINARY D. MONOLINGUAL E. MULTILINGUAL Answer: BC 答案解析: 参考:http://docs.ora

一抹曦阳-Oracle 5546

OCP-1Z0-053-V12.02-165

165.View the Exhibit exhibit1. In the CUSTOMERS_OBE table, when the value of CUST_STATE_PROVINCE is "CA", the value of COUNTRY_ID is "US." View the Exhibit exhibit2 to examine the commands and q

一抹曦阳-Oracle 7735

OCP-1Z0-053-V12.02-237

237.You executed the following commands in an RMAN session for your database instance that has failures: RMAN> LIST FAILURE; After some time, you executed the following command in the same sessio

一抹曦阳-Oracle 4958
上一篇: OCP-1Z0-053-V12.02-435题
下一篇: OCP-1Z0-053-V12.02-227题
Riveore
博客等级 码龄19年 1801粉丝 1432原创
评论 1
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值