SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to capture specific ORA error (timestamp is last 24 hrs)

JhilJul 12 2023

Dear Experts,

I am trying to fetch ORA-600 error in an Oracle Database for last 24 hrs.

Can i have better than following below Query.

SET linesize 200 pagesize 200
col RECORD_ID FOR 9999999 head ID
col MESSAGE_TEXT FOR a120 head Message
SELECT record_id, to_char(originating_timestamp,'DD.MM.YYYY HH24:MI:SS') , message_text FROM X$DBGALERTEXT WHERE originating_timestamp > systimestamp - 1 AND regexp_like(message_text, '(ORA-00600)') order by record_id;

Thanks

This post has been answered by Barbara Boehmer on Jul 13 2023

Jump to Answer

Added on Jul 12 2023

24 comments

416 views