Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

SHMALL Sizing with Oracle Automatic Memory Management (AMM)

edited Aug 30, 2013 11:25AM in Database Install/Upgrade/Opatch (MOSC) 4 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center