Re: log for dbms_output.put_line
- From: DA Morgan <damorgan@xxxxxxxxx>
- Date: Thu, 30 Mar 2006 08:53:51 -0800
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)
.
- References:
- log for dbms_output.put_line
- From: sirvinay@xxxxxxxxx
- log for dbms_output.put_line
- Prev by Date: Re: Indexing properties that belong to types
- Next by Date: Re: inexpensive SAN for Linux 10gR2 RAC
- Previous by thread: Re: log for dbms_output.put_line
- Next by thread: Re: log for dbms_output.put_line
- Index(es):
Relevant Pages
|