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? -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l