OraFAQ Forum: Training & Certification

Home » Other » Training & Certification » Oracle 9i, Windows (Granule Allocation)

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

Oracle 9i, Windows [message #325459]

Fri, 06 June 2008 04:39

priyamalhotra
Messages: 43
Registered: July 2006
Location: none

Member

Hi,

I have a query regarding the following:

Memory granules are not allocated at instance startup for which of the following SGA components?

A. Database buffer cache.

B. Shared pool.

C. Redo log buffers.

D. Large pool.

E. Java pool.

Answer: Large pool and Java pool are the expected answers is what I am thinking.

But the answers provided are not matching above answer.

Any comment would be helpful.

Thanks,
Priya.

Report message to a moderator

Re: Oracle 9i, Windows [message #325463 is a reply to message #325459]

Fri, 06 June 2008 04:47

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Administrator's Guide: Components and Granules in the SGA

Regards
Michel

Report message to a moderator

Re: Oracle 9i, Windows [message #325818 is a reply to message #325463]

Mon, 09 June 2008 00:58

priyamalhotra
Messages: 43
Registered: July 2006
Location: none

Member

Hi,

Thanks for the link.

But I am still unclear about the answer as per the article. As it state Large pool size is 0 by default.

Also, I found the statement

Quote:

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.

But what I know instead of 1 GB it is 128 MB.

http://en.wikipedia.org/wiki/Granule_(Oracle_DBMS)

If the SGA size is less than 128 MB, then each GRANULE size will be 4 MB.However if the SGA size is more than 128 MB, then each GRANULE will be 16 MB.

Is it going to alter from database version to version.

Thanks,
Priya.

[Updated on: Mon, 09 June 2008 01:37] by Moderator

Report message to a moderator

Re: Oracle 9i, Windows [message #325823 is a reply to message #325818]

Mon, 09 June 2008 01:40

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Generally speaking, it is more likely to trust Oracle documentation than Wikipedia.
Yes, it may change from version to version. Granule size is Oracle proprietary they do what they want with them.

Regards
Michel

Report message to a moderator

Re: Oracle 9i, Windows [message #325829 is a reply to message #325823]

Mon, 09 June 2008 02:09

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Now that you, priyamalhotra, know where to find official Oracle documentation, you might have taken a look at the same document which covers your (9i) database version (instead of 10g suggested by Michel).

It says ... well, what it says.

Report message to a moderator