--

-- 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')

/