Database Administration (MOSC)

MOSC Banner

How to Configure RHEL AS4 64-bit for Large SGA up to 10GB with a system RAM at 32 GB?

edited Feb 24, 2009 10:26AM in Database Administration (MOSC) 2 commentsAnswered
 Hi all:

when I first started I thought it is easy way to follow the tradition like: set init.ora sga_max size parameter, rebounce DB.  However, it gives Linux OS error with 'out of mem'/'not enough mem'

it is related to linux memory setttings (shmmax|shmmni|shmall), and SGA 'mapped_base address' during I dig out related articles.

Our system:

OS: Linux x86_64bit,  AS 4.0

Kernel: 2.6.9-55.ELlargesmp

DB: 10.2.0.3

$ cat /proc/sys/kernel/shmmax

8589934592

$ $ cat /proc/sys/kernel/shmmni

4096

$ cat /proc/sys/kernel/shmall

3279547

$ ipcs -lm

------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 8388608

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