granule size [message #501194] |
Sun, 27 March 2011 03:29 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #501196 is a reply to message #501195] |
Sun, 27 March 2011 06:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #501198 is a reply to message #501197] |
Sun, 27 March 2011 07:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #501201 is a reply to message #501198] |
Sun, 27 March 2011 08:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
muzahid
Messages: 281 Registered: September 2004 Location: Dhaka, Bangladesh
|
Senior Member |
|
|
Michel Cadot wrote on Sun, 27 March 2011 19:21So, 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 #501241 is a reply to message #501231] |
Mon, 28 March 2011 02:35 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
muzahid
Messages: 281 Registered: September 2004 Location: Dhaka, Bangladesh
|
Senior Member |
|
|
Michel Cadot wrote on Mon, 28 March 2011 12:33But 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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 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 Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8944 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.
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.
|
|
|