SQL Script Database Alerts

Updated: 20-Jul-2004
Version: 1.0

Description

Reports on any 10g Database Alerts.

Parameters

None

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

set pages 200
spool alert.lst

PROMPT
PROMPT Alerts Thresholds

col metrics_name form a30
col warning_value form a5
col critical_value form a5
col object_type form a12

select metrics_name,warning_value,critical_value, object_type from dba_thresholds;

PROMPT Outstanding Alerts
PROMPT

col reason form a34 wrap
col suggested_action form a34 wrap
col message_type form a8

select reason,suggested_action,message_type
from dba_outstanding_alerts;



PROMPT Alert History
PROMPT

col reason form a60

select reason, resolution from dba_alert_history;



spool off

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links