Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> PL/SQL Native Compilation on 9i RAC

PL/SQL Native Compilation on 9i RAC

From: Sriram Kumar <k.sriramkumar_at_gmail.com>
Date: Tue, 11 Sep 2007 19:09:52 -0400
Message-ID: <c515faee0709111609y518196d3uf5cd42b4859d8420@mail.gmail.com>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 11 2007 - 18:09:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US