Oracle has touted that they have made an effort to optimize the PL/SQL
language within Oracle, most notably the ability to compile PL/SQL
starting with Oracle9i.
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
Oracle9i: 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 Oracle9i
and 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
