Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 9i: Native vs Interpreted execution

Re: 9i: Native vs Interpreted execution

From: John Darrah <nytimesjdarrah_at_hotmail.com>
Date: 9 Dec 2004 09:57:35 -0800
Message-ID: <1102615055.733131.193190@f14g2000cwb.googlegroups.com>


Native code is a little bit more management since the code (at least in 9i) lives on the file system. It also requires a compiler and make. Not a huge deal but if you have code that is primarily SQL statements and you won't get performance gains anyway, why bother. lambu999_at_yahoo.com wrote:
> Hi all,
>
> I was reading the Concepts manual and it says from 9i you have the
> option of both native and interpreted execution available for storing
> PL/SQL program units.
>
> Why should we even have to consider interpreted execution when there
> is a native (object code) version available? Wouldnt the native
version
> be faster?
>
> Thanks.
Received on Thu Dec 09 2004 - 11:57:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US