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 -> Granule size confusion

Granule size confusion

From: Steve Robin <ocmaman_at_gmail.com>
Date: Fri, 29 Jun 2007 05:50:25 -0700
Message-ID: <1183121425.966938.183210@w5g2000hsg.googlegroups.com>


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..... ? Received on Fri Jun 29 2007 - 07:50:25 CDT

Original text of this message

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