OCP-1Z0-052-V8.02-49题

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

49. View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. 

After 30 minutes, you executed the following command:

SQL> SELECT reason,metric_value FROM dba_outstanding_alerts;

REASON METRIC_VALUE

------------------------------ ------------

Tablespace [TEST] is [28 perce 28.125

nt] full

What could be the reason for the elimination of the other rows in the output?

A.An Automatic Workload Repository snapshot has been taken recently.

B.The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.

C.The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.

D.The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but

not the threshold alerts related to instance metrics.

Answer: C  

答案解析:

 服务器生成预警分为两种类型:阈值预警和非阈值预警。
大多数服务器生成的预警是通过对数据库度量设置警告阈值和严重阈值来配置的。可为120 多个度量定义阈值,这些度量包括:
• 每秒的物理读取次数
• 每秒的用户提交次数
•SQL 服务响应时间
除了表空间的空间占用率度量与数据库相关外,其它度量都与实例相关。阈值预警又称为“有状态预警”,清空预警条件后,会自动清空这些预警。有状态预警显示在
DBA_OUTSTANDING_ALERTS中,清空后会转到DBA_ALERT_HISTORY。
服务器生成的其它预警对应于特定的数据库事件,如ORA-*错误、“快照太旧”错误、“恢复区空闲空间过少”和“可恢复会话被挂起”等。这些都不是基于阈值的预警,又称
为“无状态预警”。无状态预警会直接转到历史记录表。只在Database Control 环境中,清空无状态预警才有意义,因为Database Control 会在自身的资料档案库中存储无状态预警。
突出告警信息(DBA_OUTSTANDING_ALERTS) 2019独角兽企业重金招聘Python工程师标准>>> ... 阅读详情

相关推荐

oracle 度量 预警,Oracle的存储信息-度量信息&突出告警信息&告警历史信息

度量信息(DBA_THRESHOLDS)在第2章中已经介绍了在Oracle 10g中如何设置自动空间告警。在Oracle 10g数据库中内置了一系列的监控规则,用于监控数据库的运行情况,这些规则被称为“度量”,用户可以根据需要对度量进行调整,而这些度量正是数据库告警的基础。对于不同度量的阈值,可以通过DBA_THRESHOLDS视图进行查询:SQL>selectMETRICS_NAME,...

weixin_29421255的博客 516

oracle 锁阈值,ORACLE THRESHOLD (度量阀值)监控表空间

ORACLETHRESHOLD(度量阀值)监控表空间1、使用DBMS_SERVER_ALERT.SET_THRESHOLD过程设置针对本地管理的表空间的相关阀值。2、DBA_OUTSTANDING_ALERTS告警信息可以查看这个视图3、DBA_ALERT_HISTORY,如果告警信息解决后,DBA_OUTSTANDING_ALERTS中记录的告警信息会转换到DBA_ALERT_HISTOR...

weixin_42168230的博客 683

DBA_OUTSTANDING_ALERTS

DBA_OUTSTANDING_ALERTS describes alerts which the server considers to be outstanding. DBA_OUTSTANDING_ALERTS描述服务器认为未完成的警报。

qq_30396379的博客 493

DBA_OUTSTANDING_ALERTS 与 DBA_ALERT_HISTORY

select * from DBA_OUTSTANDING_ALERTS order by creation_time desc SEQUENCE_ID,REASON_ID,OWNER,OBJECT_NAME,SUBOBJECT_NAME,OBJECT_TYPE,REASON,TIME_SUGGESTED,CREATION_TIME,SUGGESTED_ACTION,ADVISOR_NAME,ME...

allway2的博客 806

OCP-1Z0-052-V8 02-49

OCP-1Z0-052-V8 02-49

sdfsdkk的博客 203

OCP-1Z0-052-V8.02-93

93. You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tabl

一抹曦阳-Oracle 1万+

C 语言学习笔记

B站up Micro_Frank C语言大师系列课程笔记

g_c_m_g的博客 1129

Oracle警报系统

一、警报条件监视和通知 警报系统在空间管理方面,默认的配置是在考虑自动扩展和内容本质的情况下,当表空间达到全满的85%时,将引发警告性报警。当表空间达到全满的97%时,将发出严重报警。 ...

cldh1492的博客 850

052 49 - thread alert

49. View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, you executed the following command: SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; ...

文档搬运工 480

DBA_OUTSTANDING_ALERT records alerts

If a threshold is exceeded  or an event has occurred, MMON puts an “alert” (i.e. message) on a predefined queue.  (This queuing mechanism uses Oracle’s Advanced Queuing feature.The 10g data dictio

Firefoxboy的空军基地 2059

Oracle 11G OCP 1Z0-052 41

49View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, you executed...

cmff98425的博客 110

Oracle OCP 19c 认证1Z0-083考试库(第2

2、Choose three. In which three situations can you use threshold server-generated alerts to help diagnose and fix problems? A) when free space in a dictionary managed tablespace falls below a specified percentage B) when free space in a locally managed tabl

I am not only a DBA 755

49.View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view.

49.View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view.

dwj19830118的专栏 1146

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

168.Exhibit: View the Exhibit to examine a portion of the output from the VALIDATE DATABASE command. Which statement is true about the block corruption detected by the command? A. No action is ta

一抹曦阳-Oracle 7901

DBA_OUTSTANDING_ALERTS突出告警信息

Oracle 10g通过DBA_OUTSTANDING_ALERTS视图记录了数据库活动警报信息,这些信息直到警告清除或复位才会从这个视图中消失. 说明 Oracle 数据库服务器认为处于未处理状态的预警

dwj19830118的专栏 2048

OCP-1Z0-052-V11g-49

49. View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, you executed the following command: SQL> SELECT reason,metric_value FROM dba_outstanding_alerts;

永远都没有做完的软件,只有发布的软件 965

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

162.View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has undergone workloads of different capacities: SQL> SELE

一抹曦阳-Oracle 8110

[每日一] 11gOCP 1z0-052 :2013-09-10 ABOUT ALERTS...............................................A50...

转载请注明出处:http://blog.csdn.net/guoyjoe/article/details/11546561 正确答案:AD 使用服务器生成的警报系统,从Oracle10g版本开始,Oracle数据库凭借警报系统一举实现了”自我管理”。在早期版本中,DBA必须耗费大量的精力来处理一些必需的但枯燥无味的单调工作,还必须设计多个方法,在出现异常条件时捕获这些条件。 ...

jishublog 208

042关于alter问

151. View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERT view.After 30 minutes, you executed the f...

cuichao5297的博客 224
上一篇: OCP-1Z0-052-V8.02-46题
下一篇: OCP-1Z0-052-V8.02-50题
Riveore
博客等级 码龄19年 1801粉丝 1432原创
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值