Discussion on: Oracle AWS RDS Trace files

[Project-42]

That looks great.

Are you aware of this way as well?

I didn't use for a while, but should work:

set lines 500
set pages 50
col originating_timestamp for a40
col rownum for 999999
col Error for a150
-- SET PAUSE ON
-- SET PAUSE 'Press Return to Continue'
select inst_id, rownum "Line",TO_CHAR(originating_timestamp,'DD-MON-YYYY HH24:MI:SS'), message_text "Error"
from TABLE(gv$(cursor(select inst_id, originating_timestamp, message_text
from v$diag_alert_ext
where originating_timestamp >= (sysdate - 1)
AND regexp_like(message_text, '(ORA-|error)'))))
order by originating_timestamp asc;

[Abhilash Kumar | Oracle ACE ♠ Nabhaas Cloud Consulting]

That works too , my script can be used to check contents of all kinds of trace files.

[Project-42]

Didn't know about that one, thanks for sharing!

[Abhilash Kumar | Oracle ACE ♠ Nabhaas Cloud Consulting]

You’re welcome !!!!