Re: Q: DBMS_OUTPUT display while processing?
Date: 08 Aug 1999 00:41:37 GMT
Message-ID: <19990807204137.02189.00008703_at_ng-ft1.aol.com>
>I have a large PL/SQL package with 20 procedures within the package.
>The purpose of the package is do some batch process which will take
>about 10 hours.
>
>I tried to have DBMS_OUTPUT.PUT_LINE in every single procedure to print
>out the status so that I can monitor each process(to see if there is
>errors) while the package is still running. However, the DBMS_OUTPUT
>didn't display until the whole package is done. This is very annoying.
>Is there any work around?
>
>Thanks in advance.
>
>Ed
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
>
>
Not with DBMS_OUTPUT. But look at DBMS_APPLICATION_INFO.SET_MODULE. This allows
you to set the 'ACTION' and MODULE columns of the V$SESSION view. Calling this
package does NOT require a commit for another session to see what you have
written. The downside is that the message is only 20 or 25 characters long.
I have a similar process that takes hours to run, and call this package to show the current processing (actually, the % completed and est completion time) There does not seem to be any appreciable impact on performace.
Hope this helps
Dan Hekimian-Williams
Received on Sun Aug 08 1999 - 02:41:37 CEST