2008/02/23

Minimized SGA Setting for Enterprise Manager DB Console



Oracle 11g occupy lots of memory.
Based on my experience 9i requires 60m, 10g requires 80m, 11g requires 100m at least.

Without Enterprise Manager DB Console

NAME BYTES RES
-------------------------------- ---------- ---
Fixed SGA Size 1331404 No
Redo Buffers 2641920 No
Buffer Cache Size 8388608 Yes
Shared Pool Size 71303168 Yes
Large Pool Size 0 Yes
Java Pool Size 0 Yes
Streams Pool Size 0 Yes
Shared IO Pool Size 0 Yes
Granule Size 4194304 No
Maximum SGA Size 92057600 No
Startup overhead in Shared Pool 33554432 No
Free SGA Memory Available 8388608

With running Enterprise Manager DB Console
NAME BYTES RES
-------------------------------- ---------- ---
Fixed SGA Size 1331992 No
Redo Buffers 2445312 No
Buffer Cache Size 33554432 Yes
Shared Pool Size 104857600 Yes
Large Pool Size 0 Yes
Java Pool Size 25165824 Yes
Streams Pool Size 0 Yes
Shared IO Pool Size 0 Yes
Granule Size 4194304 No
Maximum SGA Size 184135680 No
Startup overhead in Shared Pool 33554432 No
Free SGA Memory Available 16777216

Actually, it consumes 198m os memory before db console connected and 286m after db console connected.

No comments: