Read the Alert Logs on RAC via SQL

--
-- Read the Alert Logs on RAC via SQL
--
 
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
 
SELECT inst_id, originating_timestamp, MESSAGE_TEXT
FROM 
  TABLE (gv$
            (CURSOR 
              (
               SELECT inst_id, originating_timestamp, MESSAGE_TEXT
               FROM v$diag_alert_ext
               WHERE     originating_timestamp > (SYSDATE - 2)
              )
            )
         )
ORDER BY 
  inst_id, 
  originating_timestamp
/

^{Clipboard IE Only}

---

Published 1st May 2022