This query is used to check the ORA error in past one hour.
query:
COLUMN ORIGINATING_TIMESTAMP FORMAT A40
COLUMN message_text FORMAT A100
set linesize 300
SELECT ORIGINATING_TIMESTAMP , message_text
FROM X$DBGALERTEXT
WHERE originating_timestamp > (SYSDATE – 1/24)
AND message_text LIKE ‘%ORA-%’ and message_text NOT LIKE ‘ORA-03137’ AND message_text NOT LIKE ‘ORA-03149’
ORDER BY originating_timestamp
Recent Posts
