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:12:26 CDT