Re: SGA sizing OenVMS

The bulk of the memory allocated to the SGA is used for various caches, data block buffer caches, data dictionary caches and others. Allocating the right amount of space for your SGA caches can have a huge impact on your database performance. For the best performance the SGA(s) should be sized as big as possible without causing memory contention problems.

• Jim Yoshii

Frank Barbarino wrote:
>
> I'm real curious...
> why would you want to have an SGA greater them 40MB???
> Unless you have a boatload of packages and procedures
> that are real hogs? The sga I thought was mainly to hold
> packages and the data dictionary tables? Isnt it just
> wasted memory/disk space? I would love to hear back.
>
> Michael S. Abbey wrote:
> >
> > Anyone got any comments about sizing the SGA at greater than 40
> > megabytes per instance on an Alpha 8400???
> >
> > Michael
  Received on Wed Feb 19 1997 - 00:00:00 CST