PL/SQL Native Compilation on 9i RAC
- From: "Sriram Kumar" <k.sriramkumar@xxxxxxxxx>
- To: "List, Oracle-l Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 11 Sep 2007 19:09:52 -0400
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
1. Have any one of you tried PLSQL native compilation in 9i RAC?
2. I am thinking NFS/Clustered Filesystem for Shared Library. Clustered File
system is going to be an extra investment.
10g migration is in cards but would have to wait for 6 months or so.
Thanks and Regards
Sriram Kumar
Other related posts:
