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