Writing to the Oracle Alert Log Oracle Tips by Burleson Consulting

• Alert log x$dbgalertext

• OS scripts and languages - You can use UNIX/Linux utilities to write OS messages (e.g. RAM swapping alerts) into the alert log.  Of course, all procedural languages (C++) can also write messages to the Oracle alert log.
   

• PL/SQL - You can use the standard utl_file package or call the dbms_system.ksdwrt procedure to write messages to the Oracle alert log file.  See Oracle utl_file Package and Oracle alert log in stored procedure .
   

• SQL (read only) - You can define the alert log as an external table and access the alert log messages with SQL statements.  See Oracle Access your Alert Log via SQL with External Tables and Extract alert log messages with SQL.

This link on Oracle-l shows another method of writing to the Oracle alert log:

If you want to write a message to the alert log, you can use the undocumented KSDWRT procedure of the DBMS_SYSTEM package.

This procedure has two parameters, the first one must be "2" to write to the alert file, the second one is the message you want to write.

Here is an example:

execute sys.dbms_system.ksdwrt(2,to_char(sysdate)|| ' -- ');

Where the first parameter indicates the destination:

1 - Write to trace file.
2 - Write to alertlog.
3 - Write to both.