Re: PL/SQL Native Compilation on 9i RAC
- From: "Sriram Kumar" <k.sriramkumar@xxxxxxxxx>
- To: "List, Oracle-l Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 12 Sep 2007 12:20:19 -0400
Hi,
raised an SR for this and OSS has given following options. PL/SQL 9i does
not create the shared libraries in both the nodes automatically and hence
options are
1. Clusterfile system
2. NFS( workable but not recommended)
Thought sharing this could be of future help
Cheers
Sriram Kumar
On 9/11/07, Sriram Kumar <k.sriramkumar@xxxxxxxxx> wrote:
>
> 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:
