Oracle provides a procedure to insert messages to the alert log and/or trace files for testing/development purposes. This can be used to check the effectiveness of the monitoring tools/scripts used in the environment, to understand how well the monitoring tool captures the messages in the alert log.
Usage:
SQL> exec dbms_system.ksdwrt(1, 'This message goes to trace file in the udump location'); PL/SQL procedure successfully completed. SQL> exec dbms_system.ksdwrt(2, 'This message goes to the alert log'); PL/SQL procedure successfully completed. SQL> exec dbms_system.ksdwrt(3, 'This message goes to the alert log and trace file in the udump location'); PL/SQL procedure successfully completed. SQL>
To test whether your monitoring tool captures error messages such as an ORA-00600, try executing the below:
SQL> exec dbms_system.ksdwrt(2, 'ORA-00600: Testing monitoring tool'); PL/SQL procedure successfully completed. SQL>
