Read the Alert Log via SQL
--
-- Read the Alert Log via SQL
--
 
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
 
SELECT originating_timestamp, MESSAGE_TEXT
  FROM v$diag_alert_ext
 WHERE originating_timestamp BETWEEN TO_DATE ('2022-02-21T03:00:00',
                                              'YYYY-MM-DD"T"HH24:MI:SS')
                                 AND TO_DATE ('2022-02-21T08:30:00',
                                              'YYYY-MM-DD"T"HH24:MI:SS')
/


Published 1st July 2021

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License