> -----Original Message-----
> From: Sylvain Faust
> Posted At: Saturday, September 05, 1998 9:12 AM
> Posted To: misc
> Conversation: Monitoring status of PL/SQL code
> Subject: Re: Monitoring status of PL/SQL code
>
> Yes, use SFI PL/SQL Debugger.
> Full tracing, stack, variable watch and you can change the values on
> the fly as well and more.
>
> click here for details:
> http://www.sfi-software.com/sql-debug-debugger.htm
>
> read this?
> "SQL-Programmer with PL/SQL debugger for Oracle is a product that
> should be a "must have" in any Oracle development shop...Just as
> important, it is one of the most cost-effective solutions to managing
> the Oracle PL/SQL environment, in the market today."
>
> Ian Abramson
> Ian Abramson Systems Inc.
> Author: Oracle8 Tuning and Oracle8 Data Warehousing
>
>
> For full details check:
> http://www.sfi-software.com
>
> Sylvain Faust
> President
> Sylvain Faust Intl (SFI)
> 880 boul. de la Carrière, Suite 130
> Hull, Québec, Canada J8Y 6T5
>
> Tel: (819) 778-5045, Ext. 804
> Toll Free: 1-800-567-9127 ( U.S. and Canada only)
> Fax: (819) 778-7943 International; (617) 722-9389 U.S. only
> Email: sfaust_at_sfi-software.com
>
> Sylvain Faust Inc. (SFI)
> A Decade of Delivering SQL Solutions, 1988-1998
> http://www.sfi-software.com
>
> To receive news bulletins from SFI automatically, just send a blank
> email to:
> mailto:SFI-NEWS-SUBSCRIBE-REQUEST_at_peach.ease.lsoft.com
>
>
>
> -----Original Message-----
> From: Mohamad SALEH
> Sent: 9/4/98 9:42 AM
> Subject: 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 Sat Sep 05 1998 - 08:21:33 CDT
