Oracle PL/SQL Native Compilation

Thread: Oracle PL/SQL Native Compilation

Search this list only Search all lists
Oracle PL/SQL Native Compilation
United States	2008-09-18 09:30:41
I just recently "discovered"; that it is possible to do native compilation of PL/SQL code instead of interpretted compilation.  Oracle's documentation suggests that there can be a 10%-30% performance increase by using native compilation.  The biggest drawback appears to be a lot slower compilation time (3x-5x?).  (It is also indicated that PL/SQL debug tools won't work with native compilations...but I'm not sure that is big issue here.)  I would be interested to find out what experiences people have had when either switching to native compilation or attempting to do so.  Is it worth the extra wait for compilations to complete?  Have there been other problems that arise?  Is having a mixture of native and interpretted code OK or is it better to go all the way?  Our environment is a 10g database running Oracle E-Business Suite 11.5.10 Applications and quite a bit of custom code. Thanks in advance for your input. Chris --------------------------------------------------------------------- This e-mail message is intended only for the personal use of the recipient(s) named above. This message is confidential. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify the sender immediately by e-mail and delete the original message. --------------------------------------------------------------------- .