Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Monitoring status of PL/SQL code

Monitoring status of PL/SQL code

From: Robert Chung <robertch_at_mindspring.com>
Date: Sun, 30 Aug 1998 13:52:52 GMT
Message-ID: <35e94c32.489914@news.mindspring.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US