Business Intelligence (BI) - ERP - Dashboards

SGA contains the following data Structures

* Database buffer cache

* Redo log buffer

* Shared pool

* Java pool

* Large pool (optional)

* Data dictionary cache

* Other miscellaneous information

Oracle9i can change its SGA configuration while the instance is running.

With the dynamic SGA infrastructure, the sizes of the buffer cache,

the shared pool, and the large pool can be changed without shutting

down the instance.

The database buffer cache is divided into dirty list (buffers that

have been modified and are waiting to be written into disk) and the

least recently used (LRU) list. Buffers that are unmodified can be

used as free buffers.

Oracle9i supports multiple block size in a database. This is the

default block size—the block size used for the system tablespace.

You specify the standard block size by setting the initialization

parameter DB_BLOCK_SIZE.

Legitimate values are from 2K to 32K. To specify the size of the

standard block size cache, you set the initialization parameter

DB_CACHE_SIZE.

Sizes and numbers of non-standard block size buffers are specified
by the following parameters:

DB_2K_CACHE_SIZE

DB_4K_CACHE_SIZE

DB_8K_CACHE_SIZE

DB_16K_CACHE_SIZE

DB_32K_CACHE_SIZE

The Shared Pool portion of the SGA contains three memory structures

1. The Library Cache
2. Data Dictionary and
3. Control Structures. The size

of the Shared Pool can be customized using the parameter

SHARED_POOL_SIZE.

Filed under: DBA (DataBase Administrator), ERP, PL/SQL, SQL

Free Dashboards