Re: Max SGA/Global Section with Oracle 7.1.5 on AlphaVms 6.2

I run a 512Meg SGA on a 3-cpu Alpha 2100 with 1.5 gigs memory, 60gig+ database. Watch your pgflquota for your users and any 'started tasks' that might have hardcoded some values in their startup. ORACLE7 needs 2000000 pgflquo, users need 1700000. Your installation may vary depending on what you have running and your SGA size. Follow the calculations in the installation guide. If ORACLE doesn't start or your users can't connect, make the values bigger and try again.

Wayne Linton
Shell Canada Ltd.

Miguel Ward wrote:
>
> I am presently running Oracle 7.1.5 on OpenVms 6.2 on an Alpha Cluster.
>
> I have declared a global section of 32Mb which means to say I can't
> create an SGA larger than that number.
>
> Since I am purchasing additional memory would apreciate any experience
> with
> larger global sections/SGA (64 or 100Mb). Any problems, suggestions,
> what
> recommended values for wsdef, wsquota, wsextent, pglfquota?
>
> Thanks
>
> Michael Ward
> Aluar SAIC
> Argentina
Received on Wed Jul 02 1997 - 00:00:00 CDT