Whilst I'm doing some digging myself, I thought I'd post to this forum, just in case somebody has already looked for the same thing.
I want to access the CURRENT database alert log as part of a query.
V$DIAG_ALERT_EXT is a view which allows the whole range of available xml format alert logs to be accessed via SQL. Is there a specific view for just the current alert log, or a 'trick' to restrict Oracle to just examining the current alert log?
I'm on 12.1.0.2 on both Windows and Solaris 10.
I tried ... and log_name like '%log.xml' but that didn't appear to stop earlier logs being accessed.