Configure ASMM and AMM in Oracle

ORACLE -APPS DBA ADMINISTRATION

 
Objective: understanding ASMM and AMM in Oracle
Environment: Oracle 10g and 11g

References:  Oracle support – Automatic Memory Management (AMM) on 11g [ID 443746.1]

Concepts:

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

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s