Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Granule size confusion

Re: Granule size confusion

From: Steve Robin <ocmaman_at_gmail.com>
Date: Sat, 30 Jun 2007 07:02:16 -0700
Message-ID: <1183212136.246291.98770@o11g2000prd.googlegroups.com>


On Jun 29, 5:54 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> 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...
>
> Please read it again.
>
> David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -

Thanks for this link.
And I really apologies for this question as I could find it in documents also. But thanks a lot for this link. Received on Sat Jun 30 2007 - 09:02:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US