Skip to Main Content

Oracle Database Discussions

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!

V$DIAG_ALERT_EXT

unknown-3431574Dec 20 2017 — edited Dec 21 2017

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.

This post has been answered by Martin Preiss on Dec 21 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 18 2018
Added on Dec 20 2017
15 comments
1,933 views