Re: why does 11g plsql_code_type default to interpreted?
Date: Mon, 03 Mar 2008 09:01:47 -0800
> 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
> 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.orgReceived on Mon Mar 03 2008 - 11:01:47 CST