Chris,
Don't expect to see your app run faster. This only helps if
your time is being consumed by PL/SQL (actually a rather
rare source of performance lag).
This will not help your SQL, files and DB IO, or network
traffic.
If you think it might help, of course do not use it in
development, only in final testing and prod.
Paul Dorsey
Dulcian, Inc.
pdorsey dulcian.com
732 744 1116 x110
________________________________
Chris.RethemeyerRotometrics.com
Sent: Thu 9/18/2008 10:30 AM
To: Multiple recipients of list ODTUG-SQLPLUS-L
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.
------------------------------------------------------------
---------
.
|
