Search notes:

Oracle: Init parameter SGA_TARGET

Setting sga_target to a non zero value enables Oracle: Automatic Memory Management[automatich shared memory management and specifies the size of SGA.

With sga_target > 0, the following pools are automatically sized:

Buffer cache (db_cache_size)
Shared pool (shared_pool_size)
Large pool (large_pool_size)
Java pool (java_pool_size)
Streams pool (streams_pool_size)
Data transfer cache (data_transfer_cache_size)

Calculating the value for SGA_TARGET

Oracle recommends to determine a possible value for sga_target with the following query:

select (
   (select sum(value  ) from v$sga                    ) -
   (select current_size from v$sga_dynamic_free_memory)
) "sga_target"
from
  dual;

Whatever value is chosen when setting sga_target, it must be smaller than sga_max_size (otherwise an ORA-02097: parameter cannot be modified because specified value is invalid combined with ORA-56747 is thrown).

Oracle: Init parameter SGA_TARGET

Calculating the value for SGA_TARGET

See also