Granular Size [message #60439] |
Sun, 08 February 2004 19:25 |
ora
Messages: 47 Registered: June 2002
|
Member |
|
|
Hi,
Can anybody plz put some light on the term "GRANULAR SIZE".
Try to explain in detail so that all the doubts would be cleared.
Thanx
|
|
|
Re: Granular Size [message #60443 is a reply to message #60439] |
Sun, 08 February 2004 20:26 |
satish
Messages: 112 Registered: September 2000
|
Senior Member |
|
|
I feel, Oracle Database finest partical is Blocks
GRANULAR SIZE Means the db_Block_size of Oracle.
satish.
|
|
|
Re: Granular Size [message #60446 is a reply to message #60443] |
Sun, 08 February 2004 22:28 |
ora
Messages: 47 Registered: June 2002
|
Member |
|
|
Hi,
That i know that it is not what u r saying.
Thanx for the response. And be in queue with me and wait for the right answer.
|
|
|
|
Re: Granular Size [message #60457 is a reply to message #60446] |
Mon, 09 February 2004 04:38 |
Thiru
Messages: 1089 Registered: May 2002
|
Senior Member |
|
|
Are you talking about SGA Granule size ? which is the unit of allocation in a dynamic SGA
SQL> select component,GRANULE_SIZE from v$sga_dynamic_components
2 /
COMPONENT GRANULE_SIZE
---------------------------------------------------------------- ------------
shared pool 16777216
large pool 16777216
buffer cache 16777216
-- shows a granule size of 16M for my SGA
SQL> show parameter sga_max_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_max_size big integer 336679728
-- For eg)
SQL> show parameter db_cache_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_cache_size big integer 218103808
SQL> select 218103808/1024/1024 "DB_Cache_Size(M)
2 " from dual;
DB_Cache_Size(M)
-----------------
208
-- its currently 208MB
-- trying to set it to 200M
SQL> alter system set db_cache_size= 200m;
System altered.
SQL> show parameter db_cache_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_cache_size big integer 218103808
-- but its still 208MB, becos of the granule size 16M. Oracle rounds off to the multiple of granule size.
SQL> select CURRENT_SIZE from v$sga_dynamic_components where COMPONENT='buffer cache';
CURRENT_SIZE
------------
218103808
SQL> alter system set db_cache_size=192m;
System altered.
-- but when I try to set it to a multiple of 16M, say to 192M, it resizes exactly to that value specified.
SQL> select value/1024/1024 "size(M)" from v$parameter where name='db_cache_size';
size(M)
----------
192
-- the granule size is dependent on SGA size. If the total SGA size is < 128M , Granule_size = 4M , else Granule_size = 16M on most platforms. On 32 bit NT,however its 8M for sga_size > 128M.
-Thiru
|
|
|