Re: log for dbms_output.put_line



sirvinay@xxxxxxxxx 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@xxxxxxxxxxxxxxxx
(replace x with u to respond)
.



Relevant Pages

  • Re: log for dbms_output.put_line
    ... These days the load is taking long and i was planning to analyze which ... Seach asktom.oracle.com for debug.f and you will find it. ...
    (comp.databases.oracle.misc)
  • log for dbms_output.put_line
    ... we run procedures on a regular basis. ... These days the load is taking long and i was planning to analyze which ...
    (comp.databases.oracle.misc)