Re: 9i: Native vs Interpreted execution

Rauf Sarwar wrote:

> 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

What was your experience with CPU utilization and on which O/S?

Thanks.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)