Discussion:
Granule size confusion
(too old to reply)
Steve Robin
2007-06-29 12:50:25 UTC
Permalink
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..... ?
f***@cox.net
2007-06-29 12:54:43 UTC
Permalink
Post by Steve Robin
According to oracle if SGA size is more then 128 MB then Granule size
will be 16 M.
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
Steve Robin
2007-06-30 14:02:16 UTC
Permalink
Post by f***@cox.net
Post by Steve Robin
According to oracle if SGA size is more then 128 MB then Granule size
will be 16 M.
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
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.

Loading...