How to write to the alert log
database
ID: 20170320
ACCESSING DATA...
SYSTEM: ARCHIVE
FILE: HOW TO WRITE TO THE ALERT LOG
STATUS: ACTIVE
Juste in case you wondered, yes it is possible to write custom messages directly to the alert log. For this, you’ll have to use the procedure ksdwrt stored in the dbms_system supplied package. This can be a useful way to implement custom messages when you execute a stored procedure, or it can help with testing by generating alerts.
SQL> execute dbms_system.ksdwrt(2, 'TEST --- write to log');
or you can include a time-stamp as well.
SQL> execute sys.dbms_system.ksdwrt(2,to_char(sysdate)|| ' -- ');
The first parameter can be 1, 2 or 3.
-
Writes to the alert log.
-
Writes to the trace file.
-
Writes to both.