I am currently running an Oracle 11g database on a Windows 2008 Server 64 bit with 20GB memory. What would be your recommendation on memory settings for all the SGA components? This is a database supporting about 100 users, not very transaction heavy. The actual database size in datafile is about 20GB.
I can add another 8G memory to this server.
Automatic Shared Memory Management Enabled
Total SGA Size (MB) 5376
SGA Component Current Allocation (MB)
Shared Pool 2112
Buffer Cache 2752
Large Pool 64
Java Pool 256