Query the Alert Log
You can
query the database alert log using V$DIAG_ALERT_EXT to search for
log data.
V$DIAG_ALERT_EXT shows the contents of the XML-based alert log in
the Automatic Diagnostic Repository (ADR). For example, if you want to
search for ORA errors or client connection tracing, you can
query V$DIAG_ALERT_EXT. Also you can query
V$DIAG_ALERT_EXT if you want to pull the data from
these logs to another analytic solution for tracing ORA
errors, such as ORA-600 or ORA-7445.
Parent topic: Notes for Users Migrating from Other Oracle Databases