Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Monitoring status of PL/SQL code
You could also write program state data to an Oracle pipe using dbms_pipe.
Pipes are nontransactional and won't add too much overhead to a running
program. Then have another session read from the pipe and dump it
somewhere.
Mohamad SALEH <msaleh_at_orsys.fr> wrote in article
<35EFEE59.FA1A3021_at_orsys.fr>...
>
>
> 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 Wed Sep 09 1998 - 20:02:06 CDT