Re: log for dbms_output.put_line

sirvinay_at_gmail.com wrote:

> we run procedures on a regular basis. we have these
> dbms_output.put_line in between.
> These days the load is taking long and i was planning to analyze which
> step was running long than usual. For that I need the log of these
> output messages.
> Please let me know if there exists a log for these. If yes, then where
> can i find them?

Or replace all the dbms_output.put_lines with calls to Tom Kytes debug package. Seach asktom.oracle.com for debug.f and you will find it. Received on Thu Mar 30 2006 - 13:42:35 CST