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

In article <neG27.261429$Z2.3132548_at_nnrp1.uunet.ca>, "uunet" says...
>
>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
>
>

You will need to post the code (logic) you are using and describe the scenario (environment).

Have you run tkprof to see whats up?
http://asktom.oracle.com/~tkyte/tkprof.html

--
Thomas Kyte (tkyte_at_us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp