Hi,
I was going through the docs on
<b>Native Compilation</b> and got some doubt here.
>
You can speed up PL/SQL procedures by compiling them into native code residing in shared libraries. The procedures are translated into C code, then compiled with your usual C compiler and linked into the Oracle process.
You can use native compilation with both the supplied Oracle packages, and procedures you write yourself.
>
I checked our database parameters -
PLSQL_CODE_TYPE and
PLSQL_COMPILER_FLAGS .These show values as -
INTERPRETED and
INTERPRETED, NON_DEBUG respectively.
Changing them to +'NATIVE'+ will that help enhance the performance???
Also, i read somewhere that - Changing to NATIVE will not enhance the Database calls but the execution of Pl/SQL code (i.e loops and other stuff).
Is this correct?
I read a lot of stuff and ended up with 'Information Overload' ;-)
Could you please give me some pointers to this?
Thanks,
Ranit B.