Re: anyway to intentionally write to the alert log?

    
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

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated Sept 19th





----- Original Message ----- 
From: <ryan_gaffuri@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, October 21, 2004 2:28 PM
Subject: anyway to intentionally write to the alert log? 


anyway to write whatever i want to the oracle alert log? 
--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Other related posts: