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?

calls to dbms_output do not belong in production code.

Write your messages to a table or use utl_file to write them to a file in the shell.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)