Re: Granule size on windows 2000

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 18 Dec 2002 22:04:50 +1000
Message-ID: <5oYL9.5690$jM5.16538@newsfeeds.bigpond.com>

Hi Niall,

Note 148495.1 in metalink says:

"In this new model, a new unit of allocation is created called the 'Granule'. A granule is a unit of contiguous virtual memory allocation. The size of a granule depends on the estimated total SGA size, whose calculation is based on the value of the parameter SGA_MAX_SIZE. This would be 4MB if the SGA size is less than 128MB, otherwise it will be 16MB." Whether or not this is correct of course is a different matter. I played around with this before leaving Oracle and on Windows I came up with a 8MB rather than 16MB granule size.

Go figure...

Cheers

Richard

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3e004c67$0$238$ed9e5944_at_reading.news.pipex.net...
> Does anybody out there know what the granule size is on windows 2000 for
an
> SGA of larger than 128MB? Oracle 9.2 (though I can't see that that is
> relevant in this case). tahiti points me at my windows specific docs but I
> can't actually open them from technet.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
>
>
Received on Wed Dec 18 2002 - 06:04:50 CST