Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

sga_target tips Oracle Tips by Burleson

Oracle 10g sga_target (Deprecated & obsolete in 11gR2 with memory_target?)

The sga_target is set if you use Oracle’s Automatic Memory Management (AMM), this parameter is used to determine the size of your data cache, shared pool, large pool, and Java pool automatically. Setting sga_target=0 disables AMM. This parameter doesn’t need to be set if you set the memory_target.

Memory_target is used for everything that sga_target covered but now includes the PGA.  This is especially important because memory_target now includes the pga_aggregate_target.

Parameter type – Big integer

Syntax – sga_target = integer [K | M | G]

Default value – 0 (SGA automatic tuning is disabled)

Modifiable – ALTER SYSTEM

Range of values – 64 to operating system-dependent

sga_target specifies the total size of all SGA components. If sga_target is specified, then the following memory pools are automatically sized:

• Buffer cache (db_cache_size)
   

• Shared pool (shared_pool_size)
   

• Large pool (large_pool_size)
   

• Java pool (java_pool_size)