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.
Received on Sun Aug 30 1998 - 08:52:52 CDT
