Use the profile and see what it taking so long. I would go witha package
instead of a procedure that is 1200 lines long; more modular. Nevertheless,
look into the dbms_profile package. (docs or www.oracle.asktom.com)
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Rainer Herbst" <rherbst_@_rz.uni-potsdam.de> wrote in message
news:3EC4CC40.2010400@_rz.uni-potsdam.de...
> Hi *,
>
> is there any way to tune the execution of a PL/SQL procedure?
>
> Here is what I get:
> - a procedure with app. 1200 lines of code
> - a quite old SUN station running Sun-OS 5.7
> - Oracle 8.1.7
> - the procedure is in the shared area
> - the procedure does not read any big tables,
> just some lookup-tables which are in the
> db block buffer
> - the procedure returns after 5-8 seconds which is definatly
> not satisfying the management (and the devoloper, too)
> - the hitratio for procedures is .99
>
> TMHO, 5-8 seconds is much to long, but what could I do?
>
> Thanks in advance!
> Rainer
>
Received on Fri May 16 2003 - 07:37:46 CDT
