在系统监控中希望把业务处理的重要环节的结果集中管理，使用oracle提供的dbms_system可以完成此种功能。
SQL> exec dbms_system.ksdind(10);
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.87
SQL> exec dbms_system.ksdwrt(2, 'testing for alert log writing');
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.00
$ tail -10 alert_PROD.log
Sat Jul 24 09:38:40 2004
ARC0: Beginning to archive log# 4 seq# 35469
Sat Jul 24 09:38:40 2004
Thread 1 advanced to log sequence 35470
Current log# 1 seq# 35470 mem# 0: /redolog/log01a.dbf
Current log# 1 seq# 35470 mem# 1: /redolog.mirror/log01b.dbf
Sat Jul 24 09:39:00 2004
ARC0: Completed archiving log# 4 seq# 35469
Sat Jul 24 11:07:50 2004
::::::::::testing for alert log writing
http://www.dbasupport.com/oracle/ora9i/custom_messages.shtml
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/19446/viewspace-164224/ ，如需转载，请注明出处，否则将追究法律责任。
