Tracking Alert Log file by x$dbgalertext
Instead of reviewing whole alert log file for any Particular information, We can search using that key word from X$DBGALERTEXT Table.
Grep The word “Starting Up” of Alert log file from Instance.
col ORIGINATING_TIMESTAMP for a40
col MESSAGE_TEXT for a80
set linesize 500
SELECT originating_timestamp, message_text FROM sys.x$dbgalertext WHERE message_text LIKE '%Starting up%';
No comments:
Post a Comment