Home » RDBMS Server » Server Administration » Granular Size
Granular Size [message #60439] Sun, 08 February 2004 19:25 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #60455 is a reply to message #60446] Mon, 09 February 2004 04:09 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
unless you can explain in more detail, wat u are exactly looking into or in which aspect you are expecting an explanation on "GRANULAR SIZE" ,
I beleive, every one can throw a different view .
Sathish has posted ONE SUCH which is the most common one.
Re: Granular Size [message #60457 is a reply to message #60446] Mon, 09 February 2004 04:38 Go to previous message
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
Previous Topic: Space allocation problem! Please help!
Next Topic: DATA BASE LINK (Fatal Two-Task Communication Protocol Error, Oracle 8i)
Goto Forum:
  


Current Time: Tue Jan 07 22:03:02 CST 2025