Re: why does 11g plsql_code_type default to interpreted?

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 03 Mar 2008 09:01:47 -0800
Message-ID: <1204563706.775527@bubbleator.drizzle.com>


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
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Mar 03 2008 - 11:01:47 CST

Original text of this message