Xref: alice comp.databases.oracle.misc:19723 From: "Daniel Clamage" Subject: Re: Monitoring status of PL/SQL code Newsgroups: comp.databases.oracle.misc References: <35e94c32.489914@news.mindspring.com> <35EFEE59.FA1A3021@orsys.fr> Message-ID: <01bddc2b$271eb430$ea29c9cd@saturn> X-Newsreader: Microsoft Internet News 4.70.1161 Date: 9 Sep 1998 21:02:06 -0400 X-Trace: 9 Sep 1998 21:02:06 -0400, d13-42.dyn.telerama.com Organization: Telerama Public Access Internet (http://www.telerama.com) Lines: 31 Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!worldfeed.gte.net!nntp.giganews.com!newsfeed.lightning.net!newssrvr.alleghenypower.com!paperboy.telerama.com!d13-42.dyn.telerama.com 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. - Dan Clamage http://www.telerama.com/~dclamage If you haven't crashed the Server, you haven't been trying hard enough. Mohamad SALEH wrote in article <35EFEE59.FA1A3021@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. > >