Re: PL/SQL Native Compilation on 9i RAC

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_at_gmail.com> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l