Granule (Oracle DBMS)

Granule (Oracle DBMS)

In computing, a granule is a unit of contiguous (adjacent/bordering) virtual memory allocation.

In the Oracle DBMS, the Oracle server allocates granule entries at the time of instance startup, one for each granule to support the maximum size of the system global area (SGA). During the startup, each component acquires as many granules as it requires. We can say that SGA consists of linked GRANULES. If the SGA size is less than 128 MB, then each GRANULE size will be 4 MB.However if the SGAsize is more than 128 MB, then each GRANULE will be 16 MB. At least there must be 3 GRANULES for the SGA:One for Database Buffer Cache, another for Shared Pool Area and one for Redo Log Buffer.


Wikimedia Foundation. 2010.

Игры ⚽ Нужна курсовая?

Look at other dictionaries:

  • Granule — is a generic term used for a small particle or grain. The generic term is used in a variety of specific contexts.* Granule (solar physics), visible structures in the photosphere of the Sun arising from activity in the Sun s convective zone *… …   Wikipedia

  • Category:Computing terminology — From Technical terminology: Technical terminology is the specialized vocabulary of a field. These terms have specific definitions within the field, which is not necessarily the same as their meaning in common use. Jargon is similar, but more… …   Wikipedia

Share the article and excerpts

Direct link
… Do a right-click on the link above
and select “Copy Link”