Database Memory & 4030/4031 (MOSC)

MOSC Banner

About SHMMAX & SHMALL on Database Preinstall Package

Oracle Database 12.1.0.2 Enterprise Edition

Redhat Linux 6


we are going to add Memory on database server from 755GB to 883GB as well as SGA from 358GB to 4xxGB

Based on Doc 567506.1, Oracle recommends a maximum for SHMMAX of 1/2 of physical RAM

and SHMALL sum of all the SGAs on the system divided by the page size (Doc id 301830.1)


but from oracle database preinstalll package value of SHMMAX set to 4398046511104 and SHMALL set to 1073741824


Why the oracle preintall package is set to high value??

is it OK if keep this configuration??

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