Re: stored package size limitation?

Darius Carr wrote:
>
> I believe 100K is the maximum reccomend package size for 7.1.6 (and
> 7.1.4). ORACLE say that you can go to about 200K in 7.3.
>
> With a package size of 100K you may hit serious memory allocation
> problems when trying to execute the package in a production
> environment when it is in competition with other packages for shared
> memory and you may have to think about pinning the package.
>
> You may also find you need a massive shared pool.

You can avert this problem by allocating larger chunks of memory to the shared pool and then pinning the packages in the pool (so they cannot be swapped in/out). Related performance problems are almost always caused by fragmentation of the shared pool as packages are moved in and out. Before pinning your packages, make sure you shared pool is big enough to accommodate it. Received on Sat Jul 13 1996 - 00:00:00 CEST