SHMALL Sizing with Oracle Automatic Memory Management (AMM)
I have listed my environment, some pertinent information from Oracle and some non-sourced findings.
My questions are at the bottom. Some questions may not be relevent based on the answers provided.
ENVIRONMENT
Three Node RAC Cluster
Single Database
Oracle Linux 5 Update 2
Oracle Grid Infrastructure 11gR2 (11.2.0.2.0)
- Oracle Automatic Storage Management 11gR2 (11.2.0.2.0)
Oracle Database 11gR2 (11.2.0.2.0) Enterprise Edition with RAC option
RAM Currently: 16 Gb Soon to be Upgraded to: 32 Gb
DEFINITION
SHMALL is the total amount of shared memory, in pages, that the system can use at one time.
ORACLE SIZING RECOMMENDATIONS
Oracle Doc ID 301830
Set shmall equal to the sum of all the SGAs on the system, divided by the page size.