Home » RDBMS Server » Server Administration » granule size
granule size [message #501194] Sun, 27 March 2011 03:29 Go to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
I want to know what is the size of each granule for oracle 10g.
I read it from the following link
http://download.oracle.com/docs/cd/B13789_01/server.101/b10739/create.htm#BABHJAGE.
There it is decribed that

Quote:

The memory for dynamic components in the SGA is allocated in the unit of granules. Granule size is determined by total SGA size. Generally speaking, on most platforms, if the total SGA size is equal to or less than 1 GB, then granule size is 4 MB. For SGAs larger than 1 GB, granule size is 16 MB. Some platform dependencies may arise. For example, on 32-bit Windows NT, the granule size is 8 MB for SGAs larger than 1 GB. Consult your operating system specific documentation for more details.


Now My query about full list of granule size for different platform like windows 64 bit, unix etc.
Re: granule size [message #501195 is a reply to message #501194] Sun, 27 March 2011 05:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
 
select component, granule_size/1024/1024 from v$sga_dynamic_components;


Regards
Michel

[Updated on: Sun, 27 March 2011 05:37]

Report message to a moderator

Re: granule size [message #501196 is a reply to message #501195] Sun, 27 March 2011 06:16 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
Actually i want to know the granule size of different platform. like
OS	bit	sga_max_size	granule_size
windows	32	< 1GB		4MB
windows	32	>= 1GB		8MB
Windows	64	< 1GB		?
Windows	64	>= 1GB		?
.
.
.
.
Unix	32	<1GB		?
Unix	64	<1GB		?

Re: granule size [message #501197 is a reply to message #501196] Sun, 27 March 2011 06:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Good luck!
Post it here when you'll find them.

What do you want to know this?

Regards
Michel
Re: granule size [message #501198 is a reply to message #501197] Sun, 27 March 2011 07:03 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
Ok if i find the answer i will post it here.

9i or earlier it was 4MB for sga_max size less than or equal to 128MB and 16MB for greater than 128MB. But from 10g it varies from platform as per documenation.
Re: granule size [message #501200 is a reply to message #501198] Sun, 27 March 2011 08:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So, what do you want to do with that information? Why do you need to know for ALL platforms and versions and so on?

Regards
Michel
Re: granule size [message #501201 is a reply to message #501198] Sun, 27 March 2011 08:47 Go to previous messageGo to next message
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
Senior Member
muzahidul islam wrote on Sun, 27 March 2011 07:03

9i or earlier it was 4MB for sga_max size less than or equal to 128MB and 16MB for greater than 128MB. But from 10g it varies from platform as per documenation.

Are you sure of this? That may be what the docs said, but while it was correct for some platforms (Solaris, for instance?) I'm sure I remember Windows having 8M granules.
Probably the truth can be found only by extensive experiments.
Re: granule size [message #501219 is a reply to message #501201] Sun, 27 March 2011 23:23 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
Thanks john Watson.
I got it from http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/create.htm#998095
Quote:

The memory for dynamic components in the SGA is allocated in the unit of granules. Granule size is determined by total SGA size. Generally speaking, on most platforms, if the total SGA size is equal to or less than 128 MB, then granule size is 4 MB. Otherwise, granule size is 16 MB.

However, there may be some platform dependency. For example, on 32-bit Windows NT, the granule size is 8 MB for SGAs larger than 128 MB. Consult your operating system specific documentation for more details.

and Test it
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> select component, granule_size/1024/1024 from v$sga_dynamic_components;

COMPONENT                                                        GRANULE_SIZE/1024/1024
---------------------------------------------------------------- ----------------------
shared pool                                                                           8
large pool                                                                            8
buffer cache                                                                          8

SQL> 

Re: granule size [message #501220 is a reply to message #501200] Sun, 27 March 2011 23:26 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
Michel Cadot wrote on Sun, 27 March 2011 19:21
So, what do you want to do with that information? Why do you need to know for ALL platforms and versions and so on?

Regards
Michel


Michel......... I just curicious to know that.
Re: granule size [message #501231 is a reply to message #501220] Mon, 28 March 2011 01:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But why? There is a reason for your curiosity, you have something in mind.

Regards
Michel
Re: granule size [message #501241 is a reply to message #501231] Mon, 28 March 2011 02:35 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
Michel Cadot wrote on Mon, 28 March 2011 12:33
But why? There is a reason for your curiosity, you have something in mind.

Regards
Michel

In oracle 9i OCP exam book its stated that 4M and 16M, but when i examined the value with v$sgainfo view then i saw dissimilarity, that why i am curicious. There is nothing more in my mind.
Re: granule size [message #501244 is a reply to message #501241] Mon, 28 March 2011 02:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So to answer, it is currently 4M, 8M, 16M or more but could be other ones depending on OS and Oracle version up to 5 decimals.
In short, you can't know it until you query the view.

Regards
Michel

[Updated on: Mon, 28 March 2011 02:58]

Report message to a moderator

Re: granule size [message #501273 is a reply to message #501241] Mon, 28 March 2011 05:28 Go to previous message
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
Senior Member
Quote:
In oracle 9i OCP exam book its stated that 4M and 16M,
You are reading the wrong book! The books I wrote are better. Smile
This is from my Oracle Press 10g All-In-One Exam guide:

Quote:

SGA components are, with the exception of the log buffer, sized in granules.
A granule is an area of contiguous memory. The granule size is platform specific and
varies according to the total size of the SGA. Typical granule sizes are 4MB if the total
SGA is no bigger than 1000MB or 16MB if it is larger, but there are platform variations.
For instance, on Windows, the granule size is 8MB for an SGA greater than 1GB.

You can still buy it from Amazon, but you should buy the 11g ones now.
Previous Topic: Database Configuration Assistant not working When i want to create new database
Next Topic: keep buffer
Goto Forum:
  


Current Time: Thu May 09 00:14:21 CDT 2024