Home » Other » Training & Certification » Oracle 9i, Windows (Granule Allocation)
icon6.gif  Oracle 9i, Windows [message #325459] Fri, 06 June 2008 04:39 Go to next message
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.

Re: Oracle 9i, Windows [message #325463 is a reply to message #325459] Fri, 06 June 2008 04:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Administrator's Guide: Components and Granules in the SGA

Regards
Michel
icon6.gif  Re: Oracle 9i, Windows [message #325818 is a reply to message #325463] Mon, 09 June 2008 00:58 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Oracle 9i, Windows [message #325829 is a reply to message #325823] Mon, 09 June 2008 02:09 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
icon6.gif  Re: Oracle 9i, Windows [message #325841 is a reply to message #325829] Mon, 09 June 2008 03:01 Go to previous messageGo to next message
priyamalhotra
Messages: 43
Registered: July 2006
Location: none
Member



Hi,

Thanks for the link on 9i.

Thanks,
Priya.

icon10.gif  Re: Oracle 9i, Windows [message #340644 is a reply to message #325841] Wed, 13 August 2008 10:35 Go to previous message
priyamalhotra
Messages: 43
Registered: July 2006
Location: none
Member


Hi,

Thanks for this valued reply.

Here is another link that would be useful.

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

Thanks,
Priya.

[Updated on: Wed, 13 August 2008 13:05]

Report message to a moderator

Previous Topic: Pl/sql
Next Topic: Urgent help needed
Goto Forum:
  


Current Time: Thu Mar 28 20:54:54 CDT 2024