www.oracle-wiki.net SQL Library
-- -- 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') /