1. 首页
  2. IT资讯

042关于alter问题

151. View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERT view.

After 30 minutes, you executed the following command:

SQL> SELECT reason,metric_value FROM dba_outstanding_alerts;

REASONMETRIC_VALUE

—————————————————————————–

Tablespace [TEST] is [28 percent] full 28.125

What could be the two reasons for the elimination of the other rows in the output? (Choose two.)

A) The threshold alert conditions are cleared.

B) The threshold alerts are transferred to DBA_ALERT_HISTORY.

C) The non-threshold-based 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答案:AB 理解不来这道题,麻烦大师们解释下。

[@more@]我是这样理解的,我是菜鸟,请行家指点。 经过参考这个 http://empo007.itpub.net/post/12076/465449 和 http://space.itpub.net/?471666/viewspace-217128先搞清 : DBA_OUTSTANDING_ALERTS : 描述了oracle数据库认为是突出的警告。当向 Flash Recovery中添加或删除文件等变化都将记录在数据库的 alert 日志中,Oracle 10g 也针对该新特性提供了一个新的视 图 ,通过该视图可以得到相关的信息。 dba_alert_history: 代表了不在突出的有时间限制的历史告警 threshold_alert : 是超过备份阈值时引发的警报   ORACLE的一些内部组件可以周期性进行监控的动作,对发现的问题产生相应的alert信息。alert信息的产生是基于一些threshold值或者特定事件。基于threshold的alert信息会自DBA_OUTSTANDING_ALERTS视图中找到,当被clear的时候,这些状态的警告会进入DBA_ALERT_HISTORY

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/450962/viewspace-1027697/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:布吉卡,转转请注明出处:http://www.cxybcw.com/194758.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code