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...
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment