Environment: Oracle 10g and 11g
References: Oracle support – Automatic Memory Management (AMM) on 11g [ID 443746.1]
The SGA is a group of shared memory structures, known as SGA components, that contain data and control information for one Oracle Database instance.
A PGA is a memory region that contains data and control information for a server process. It is nonshared memory created by Oracle Database when a server process is started
There is one PGA for each server process. Background processes also allocate their own PGAs.
ASMM: Automatic Shared Memory Management (ASMM) was introduced in 10g. You enable the automatic shared memory management feature by setting the SGA_TARGET parameter to a non-zero value.
AMM: Automatic Memory Management is being introduced in 11g
SGA: contains database buffer cache, redo log buffer, shared pool, large pool, Java pool and streams…
View original post 357 more words