Did you know... Writing to the alert log?

Came upon this post during my travels. Jonathan Lewis reveals how to write a string to the Alert Log, Current Session Trace File, or Both. Also a few misc functions are included.
dbms_system.ksdwrt(1,'test')
    writes to alert log

dbms_system.ksdwrt(2,'test')
    writes to session's trace file

dbms_system.ksdwrt(3,'test')
    writes to both

see also 
    dbms_system.ksddt - writes a date-time stamp
    dbms_system.ksdind(N) - indents text using ":' characters
    dbms_system.ksdfls - flushes the write to file

Regards

Jonathan Lewis
Tags: 

Add new comment