Re: Logon trigger questions

dbaplusplus_at_hotmail.com wrote:
> Thanks a lot for your help. I did not know about ksdwrt function. It
> does let me write in alet log. Simnce ORA- errors are
> monitored using OEM in our environment, this function is a boon.

Thanks for reminding me as you are correct. For those interested there is a demo in Morgan's Library at www.psoug.org. Click on DBMS_SYSTEM.

In addition to KSDWRT there are a couple of other related capabilites that may be of interest:

KSDDDT: Prints the date stamp to the target file (alert log and/or trace file)
KSDFLS: Flushes any pending output to the target alert log or trace file KSDIND: Does an 'indent' before the next write (ksdwrt) by printing that many colons (:) before the next write.

Also documented on the Morgan's Library page with a demo.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)