Monday, September 19, 2011

Script to find Outstanding Alerts


SELECT
       To_Char(Creation_Time, 'DD-MM-YYYY HH24:MI') ct
     , instance_name        
     , object_type          
     , message_type      
     , message_level    
     , reason          
     , suggested_action
  FROM
       dba_outstanding_alerts
 ORDER BY
     By Creation_Time;

No comments:

Post a Comment