Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: PL/SQL vs PROC Performance Issue - Oracle 8.1.6

Re: PL/SQL vs PROC Performance Issue - Oracle 8.1.6

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Tue, 10 Jul 2001 09:48:02 -0700
Message-ID: <3B4B31C1.7AD4EA4C@attws.com>

uunet wrote:

> We have an AIX server running Oracle 8.1.6.
>
> OS : AIX 4.3.3 (64 bit)
> Oracle: 8.1.6.2.0
> # CPU's: 12 (450 MHz processors)
> Memory: 40 GB (RAM)
> Oracle: 8.1.6.2.0
>
> PL / SQL script does an UPDATE/COMMIT of 10,000 records in 2 Secs.
> PROC program doing the exact same UPDATE/COMMIT of 10,000 records takes
> 100 secs.
>
> Question: Why is PROC 50 times slower than PL/SQL ?
>
> On our Developer workstations, the PL/SQL to PROC performance ration is
> about 2-3.
>
> Need help from the Oracle Gurus out there to identify the bottleneck w.r.t.
> PROC program.
> System was 99% idle and these tests were run in stand alone mode.
>
> Rath

It would be very helpful to see the actual code. Because I have never experienced anything like what you describe.

So my first instinct is that the code is not, in fact, identical.

Daniel A. Morgan Received on Tue Jul 10 2001 - 11:48:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US