Re: 9i: Native vs Interpreted execution

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 9 Dec 2004 08:16:48 -0800
Message-ID: <1102609008.879895.56510@f14g2000cwb.googlegroups.com>

BTW... 9i was Oracle's first crack at native execution in a major release.... according to them, it's been enhanced quite a bit in 10g.

Native execution does not automatically mean light speed. You have to see which code you want to execute natively and which one interpreted. e.g. You have a package A and 95% of the code in it executes DML's. Native execution of this will probably give you miniscule performance gain because Oracle compiler still has to parse the SQL queries "the old fashioned" way... so this may not be a good candidate. However if package A executes mostly string comparisons, mathematical operations (Pure PLSQL) etc which does not involve DML's then this package can benefit from native execution.

Our company, in colaboration with Oracle, did some tests on 10g by natively compiling few of our frequently used pure PLSQL (No DML) intensive packages. The performance gain was upto 20%.

So yes... it can make things faster but you have to see which code will truly benefit from it.

Regards
/Rauf Received on Thu Dec 09 2004 - 10:16:48 CST