Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: A bit of fun
Neat! I just ran this on 9.2.0.2 on Tru64 and the first run was 1.96
seconds. I don't have any other versions on the same host, so I ran it
2 more times and got 1.81 and 1.75 respectively. From there it seemed
to remain constant.
Do you have native compilation enabled in 10g? AFAICR, my research indicated that there are some parameters that default to interpreted rather than compiled PL/SQL. I could be misremembering but I think that was the conclusion I came to.
Stephen
>>> Jared.Still_at_radisys.com 07/20/04 09:41AM >>>
While perusing a paper from OOW Australia:
http://download-west.oracle.com/openworld/melbourne/all_melbourne_ppts/DB_B_09.PDF
I noticed the claim that 10g PL/SQL is 2x faster than 9i PL/SQL.
Further reading showed the native compilation helped bolster that
claim,
but
nonetheless it sounded like an interesting diversion before heading
off
to the Change Control Meeting.
Using my trusty prime generator, the following times were given for
generating
all primes up < 100,000.
8i: 4.1 seconds 9i: 1.9 seconds
Though interpreted PL/SQL in 10g does not appear to be 2x faster than
in
9i,
there is still a fair bit of improvement.
This is admittedly not a thorough test, but only takes a few minutes.
Code is at http://www.cybcon.com/~jkstill/prime6.html if interested.
Jared
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Jul 20 2004 - 14:08:21 CDT