Re: fixed size

Jonathan already gave a good answer on why the platform makes a difference. From his answer, I suspect that it also makes a difference if you are using 32-bit or 64-bit Oracle. If you examine the x$ksmfsv table, you can see that each named component of the fixed SGA is a different type (KSMFSTYP column). For example, some are "word" while others can be Oracle internal structures. These can vary in size from platform to platform.

Examining two different Oracle versions (both of mine running on Solaris 7), I see that Oracle 8.0.6 has 2,294 named components in the fixed SGA while Oracle 8.1.6 has 2,996 components. The Oracle 8.0.6 version has a fixed SGA size of 51,632 bytes while the 8.1.6 version is 69,616 bytes. Oracle can change the fixed SGA from version to version to support new features, etc.

HTH,
Brian

oracle wrote:
>
> Oracle 8.1.6 running on SUN Solaris (2.7)(Ultra BOX). Anyways how does
> it matter of version and platform??? I'm curious to know. Thanks for
> your help.
>
> In article <3A6DA5F3.BCF909E6_at_edcmail.cr.usgs.gov>,
> Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:
> > > > And on what parameters is it based on.
> >
> > IIRC, the fixed size of the SGA is version (and platform?) dependent.
> >
> > HTH,
> > Brian
> >
> > --
> > ========================================
> > Brian Peasland
> > Raytheons Systems at
> > USGS EROS Data Center
> > These opinions are my own and do not
> > necessarily reflect the opinions of my
> > company!
> > ========================================
> >
>
> Sent via Deja.com
> http://www.deja.com/
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================