Did you know... Writing to the alert log?
Submitted by dave on Fri, 10/01/2010 - 13:15
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