PL/SQL far faster in Oracle10g

Oracle has reduced the code paths for PL/SQL for every release, making PL/SQL far faster then ever before.

Jared Still, a guru Oracle professional has recently created an easy test to prove the optimization of PL/SQL between Oracle versions.

Still created a timing test with interpreted PL/SQL that generated all prime numbers up to 100,000.  Here are his results:

Oracle8i:      4.1 seconds
Oracle:      1.9 seconds
Oracle10g:     1.4 seconds

While not representative of all possible PL/SQL operations, it confirms that PL/SQL may run twice as fast when migrating to Oracleand 25% faster when migrating from Oracle19 to Oracle10g.

If you have thousands of PL/SQL executions every minutes, these improvements can make a huge difference in server resource consumption.

Jared's code test is at http://www.cybcon.com/~jkstill/prime6.html.
 

Oracle Fast Guide

Get the troubleshooting advice you need to quickly solve Oracle errors. Activate your membership to SearchOracle.com and access the ?Solving Common Oracle Errors Fast Guide.?

Download now