Sga Size

SQL> startup ORACLE instance started. Total System Global Area 1258291200 bytes Fixed Size

1978336 bytes

Variable Size

318771232 bytes

Database Buffers

922746880 bytes

Redo Buffers

14794752 bytes

Database mounted. Database opened.

SQL> select * from v$sga; NAME

VALUE

-------------------- ---------Fixed Size

1978336

Variable Size

318771232

Database Buffers Redo Buffers

922746880 14794752

The output from this query shows that the total size of the SGA is 1258291200 bytes. This total size is composed of the variable space that is composed of the Shared Pool, the Large Pool, and the Java Pool (318771232 bytes), the Database Buffer Cache (922746880 bytes), the Redo Log Buffer (14794752 bytes), and some additional space (1978336 bytes) that stores information used by the instance’s background processes.

SQL> select component,current_size from v$sga_dynamic_components; COMPONENT

CURRENT_SIZE

---------------------------------------------------------------- -----------shared pool

285212672

large pool

16777216

java pool

16777216

streams pool DEFAULT buffer cache

0 922746880

KEEP buffer cache

0

RECYCLE buffer cache

0

DEFAULT 2K buffer cache

0

DEFAULT 4K buffer cache

0

DEFAULT 8K buffer cache

0

DEFAULT 16K buffer cache

0

COMPONENT --------------------------------------------------------DEFAULT 32K buffer cache ASM Buffer Cache 13 rows selected. SQL>

CURRENT_SIZE -----------0 0