setlines500setpages50coloriginating_timestampfora40colrownumfor999999colErrorfora150-- SET PAUSE ON-- SET PAUSE 'Press Return to Continue'selectinst_id,rownum"Line",TO_CHAR(originating_timestamp,'DD-MON-YYYY HH24:MI:SS'),message_text"Error"fromTABLE(gv$(cursor(selectinst_id,originating_timestamp,message_textfromv$diag_alert_extwhereoriginating_timestamp>=(sysdate-1)ANDregexp_like(message_text,'(ORA-|error)'))))orderbyoriginating_timestampasc;
That looks great.
Are you aware of this way as well?
I didn't use for a while, but should work:
That works too , my script can be used to check contents of all kinds of trace files.
Didn't know about that one, thanks for sharing!
You’re welcome !!!!