Generate ORA error in Alert log file with dbms_system.ksdwrt Oracle

We can generate entry in alert log file for making alerts on specific things with help of dbms_system package.

It help us to configured alert for us in alert log file. We can monitor alert log file with lot of monitoring tools which will help us when specific condition occurred in database or application level then we get alert in alert log file of Oracle.

Generate your own error in alert log file

dbms_system.ksdwrt is the package used to write in alert log.

Syntax:
Execute the following command to write any message in alert log.

Example:
To write on alert log file through package, we are monitoring ETL job with alert log if record above 600000 then it write message in alert log.