Wednesday, July 9, 2008

Memory Management Oracle 11G - Overview

This is a quick overview, for situation when there is no time left reading document, it just need to be fixed then reviewed later on.
Two-memory structure A+B

A include:
1-DB_CACHE_SEIZE important, sample value 1Giga
2-JAVA_POOL_SEIZE 32 M
3-LARGE_POOL_SEIZE 16M
4-SHARED_POOL_SEIZE important, 2Giga

SGA_TARGET = 1+2+3+4 (So any of these 1,2,... if increased , that amount should be added to SGA_TARGET

B include
PGA_AGGREGATE_TARGET very important, 10Giga
Total memory is called memory target

MEMORY_TARGET= A + B

Also Oracle 11g provide automatic memory management and through enterprise manager memory adviser is good tool to monitor memory.

I will append to this article, this is not complete...

0 comments: