Re: why does 11g plsql_code_type default to interpreted?

From: DA Morgan <>
Date: Mon, 03 Mar 2008 09:01:47 -0800
Message-ID: <>

hpuxrac wrote:
> I have a test system running 11g 64 bit on OEL 4. Created a new
> database ( custom ... not from template with pre-suppplied
> datafiles ).
> It seems kind of curious that oracle is defaulting plsql_code_type to
> interpreted.
> If the native is so much faster ... and you don't need a compiler/etc
> anymore ... why is this happening for a new database?
> Are there a bunch of bugs and caveats that are still being experienced
> in this area? Maybe this default will eventually change by 11.2?

Consider the implication of exporting a procedure if you have compiled code versus pcode. You might well choose to import it into a different environment.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Mon Mar 03 2008 - 11:01:47 CST

Original text of this message