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

最新推荐文章于 2023-07-26 18:19:32 发布
原创 最新推荐文章于 2023-07-26 18:19:32 发布 · 1.1w 阅读 · 1 ·
本内容遵循CC 4.0 BY-SA版权协议
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
收录于
OCP11g解析

当前文章被收录于：

OCP11g解析
870 篇文章 151 人学习

OCP11g，051,052,053每题的解析

订阅专栏 查看详情
OCP-1Z0-053

当前文章被收录于：

OCP-1Z0-053
796 篇文章 0 人学习
订阅专栏 查看详情
深入探讨数据库实例中资源消耗细节，分析当前计划使用情况，解析用户组资源分配及等待时间，理解CPU等待时间与资源管理的关系。

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

OCP-1Z0-053-V12 02-20题
sdfsdkk的博客
01-17 139
OCP-1Z0-053-V12 02-20题
OCP-1Z0-053-V12.02-501题
热门推荐
一抹曦阳-Oracle
10-01 1万+
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
OCP 11G 053题库解析汇总链接(201-400)
u011443258的博客
07-26 129
racle OCP 11G 053（201-400）答案解析目录
OCP-1Z0-053-V12.02-185题
一抹曦阳-Oracle
11-07 7650
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
OCP-1Z0-053-V12.02-446题
一抹曦阳-Oracle
11-09 4566
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
OCP-1Z0-053-V12.02-115题
一抹曦阳-Oracle
11-07 8427
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
OCP-1Z0-053-V12.02-156题
一抹曦阳-Oracle
10-23 6608
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
OCP-1Z0-053-V12.02-510题
一抹曦阳-Oracle
10-07 1万+
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
OCP-1Z0-053-V12.02-96题
一抹曦阳-Oracle
11-01 1万+
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
OCP-1Z0-053-V12.02-22题
一抹曦阳-Oracle
11-01 7091
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
OCP-1Z0-053-V12.02-464题
一抹曦阳-Oracle
11-13 5543
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
OCP-1Z0-053-V12.02-244题
一抹曦阳-Oracle
11-07 6331
244.Which two statements are true regarding the starting of the database instance using the following command? (Choose two.) SQL>STARTUP UPGRADE A. It enables all system triggers. B. It allows onl
OCP-1Z0-053-V12.02-78题
一抹曦阳-Oracle
10-07 8510
78.You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATAB
OCP-1Z0-053-V12.02-165题
一抹曦阳-Oracle
11-07 7735
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
OCP-1Z0-053-V12.02-237题
一抹曦阳-Oracle
10-07 4953
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
OCP-1Z0-053-V12.02-459题
一抹曦阳-Oracle
11-13 5455
459.What elements of globalization can be explicitly defined using the NLS_LANG environment variable? (Choose all that apply.) A. NLS_LANGUAGE B. NLS_SORT C. NLS_CALENDAR D. NLS_CHARACTERSET E.
OCP-1Z0-053-V12.02-217题
一抹曦阳-Oracle
11-07 6721
217.Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the foll
OCP-1Z0-053-V12.02-92题
一抹曦阳-Oracle
01-26 7820
92.You observed the following output for a user session: What do you infer from the preceding output? A. Resumable set for session with sid 18 B. The user session has entered into a deadlock
Note-Station-to-markdown
最新发布
07-17
这是一个跨平台脚本，可将 Synology Note Station 的笔记转换为 Markdown 文件。脚本使用 Python 编写，可在任何桌面平台上运行。 转换后您将获得： 1、以导出的笔记本命名的文件夹； 2、这些文件夹中以所有内联图片原位存储的 Markdown 语法纯文本文件笔记； 3、在笔记文本开头处分配标签和附件链接； 4、所有图片和附加文件都位于笔记本目录下的媒体子目录中。
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值