Re: Monitoring status of PL/SQL code

Robert Chung a écrit:

> We have a PL/SQL batch program that used to take 12 hours to run but
> suddenly started taking 22 hours to run. I would like to find some
> way to monitor the status of local variables in this PL/SQL code while
> it is running by opening *another* SQLPlus or Server Manager session.
> Using dbms_output.put() is of no use because the output are hold in
> buffer until the end of code execution. Dumping output to a file
> would generate a file to big to handle. Is there any simple way to
> see values of variables in PL/SQL code currently executing? Thanks in
> advance.

I am not sure of it because I never used it but it seems that Procedure Builder has a debugger and can
do it for you. Received on Fri Sep 04 1998 - 08:42:49 CDT