Re: Granule size confusion

On Jun 29, 7:50 am, Steve Robin <ocma..._at_gmail.com> wrote:
> According to oracle if SGA size is more then 128 MB then Granule size
> will be 16 M.
>
> But in my database:
>
> sys ----- OEMREP> show parameter sga_max_size
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> sga_max_size big integer 143728252
> sys ----- OEMREP> show sga
>
> Total System Global Area 143728252 bytes
> Fixed Size 454268 bytes
> Variable Size 109051904 bytes
> Database Buffers 33554432 bytes
> Redo Buffers 667648 bytes
> sys ----- OEMREP> select
> COMPONENT,CURRENT_SIZE,MAX_SIZE,MIN_SIZE,GRANULE_SIZE from V
> $SGA_DYNAMIC_COMPONENTS;
>
> COMPONENT CURRENT_SIZE MAX_SIZE MIN_SIZE GRANULE_SIZE
> -------------------- ------------ ---------- ---------- ------------
> shared pool 50331648 50331648 50331648 4194304
> large pool 8388608 8388608 8388608 4194304
> buffer cache 33554432 33554432 33554432 4194304
>
> Oracle Version : 9.2.0.8
> Platform : Windows XP
> Please let me know why..... ?

Windows. Please read the documentation on granule size again and you'll discover that Windows does not follow the 'guidelines' posted for Unix systems. The granule size for Windows platforms is 4 meg up until the SGA reaches 1 gigabyte or greater in size, at which time it becomes 8 meg. This is clearly stated here:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm#sthref380

Please read it again.

David Fitzjarrell Received on Fri Jun 29 2007 - 07:54:43 CDT