Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> PL/SQL Native Compilation on 9i RAC
Folks,
Environment: Oracle 9i 9.2.0.4 RAC on HP-UX 11.11
We have some memory intensive PLSQL code units which perform better when compiled in Native .We have seen good benefit on non RAC environments in 9i.
We have a setup that is RAC. Have tried compiling this unit in Native but the shared library does not seem to get "automatically" propagated to the other nodes of RAC but able to compile in respective nodes and create the shared libraries. I am frankly not in favour of this model as this unit might undergo some changes and might be operationally difficult to compile/verify that the unit in all nodes of RAC
My question are
10g migration is in cards but would have to wait for 6 months or so.
Thanks and Regards
Sriram Kumar
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 11 2007 - 18:09:52 CDT