Query to find the Outstanding Database Alerts in Oracle DB
TO know what are the top database Alerts, use the below query
SELECT
To_Char(Creation_Time, 'DD-MM-YYYY HH24:MI')
Creation_Time,instance_name,object_type,message_type,message_level,reason,suggested_action
FROM
dba_outstanding_alerts
ORDER BY Creation_Time;
No comments:
Post a Comment