Query From Sys.X$DBGALERTEXT Does Not Show Recent Alert Log File Entries (Doc ID 2262659.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Old entries are seen in sys.X$DBGALERTEXT, whereas alert log file reflects recent entries.


SQL> select sysdate from dual;

SYSDATE
---------
16-MAR-17

SQL> select max(ORIGINATING_TIMESTAMP) from sys.X$DBGALERTEXT ;

MAX(ORIGINATING_TIMESTAMP)
---------------------------------------------------------------------------
08-DEC-16 08.56.24.944 PM +03:00

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms