Re: Tuning PL/SQL

Jim Kennedy wrote:

> 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

Good try, Jim. But the super-duper Tom Kyte page (I assume that this is what you were referring to) is actually at http://asktom.oracle.com.

FYI. TG

>
>
> --
> 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 - 09:53:35 CDT