OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » granule size

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

granule size [message #169297]

Wed, 26 April 2006 02:50

abs_amit
Messages: 59
Registered: January 2006
Location: delhi

Member

hi All

i read in a book that granule is minimum unit of memory allocation and deallocation to the SGA and its size is
4 mb if sga<128 otherwise
16 mb

i am confused that if i am increasing just 2 mb in Database buffer cache so 4 mb or 16 mb will be increased.
i dont think so.....
so explain it
and tell me from where i can find the size of a granule.

Thanks in advance.

Report message to a moderator

Re: granule size [message #169307 is a reply to message #169297]

Wed, 26 April 2006 03:38

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

If the sga is 100m and the buffer cache is 24m if you try to increase the buffer cahe to 22m it will automatically change it to 24M in size.
That is it, basically.

Jim

Report message to a moderator

Re: granule size [message #169429 is a reply to message #169297]

Wed, 26 April 2006 16:21

Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas

Senior Member

Hi,

In 10g if total SGA size is less than 1 GB then the Granule size would be 4 MB otherwise 16. And you are right it is used to de/allocate various memory segments of SGA. You can check the granule size of you database by quering either V$SGAINFO or V$SGA_DYNAMIC_COMPONENTS.

Daljit Singh

Report message to a moderator

Previous Topic:	Database migration
Next Topic:	default size of rollback and undo space

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:34:19 CDT 2024