Database Tuning (MOSC)

MOSC Banner

Increasing MEMORY_MAX_TARGET - 11.2.0.3 and /dev/shm

edited Oct 15, 2013 7:00AM in Database Tuning (MOSC) 9 commentsAnswered

Hi

In our 11.2.0.3 RAC database, we have the following memory settings

memory_max_target                    big integer 6368M
    memory_target                        big integer 6368M

SQL> show sga

Total System Global Area 2772574208 bytes
Fixed Size                  2229720 bytes
Variable Size            2684357160 bytes
Database Buffers           67108864 bytes
Redo Buffers               18878464 byte

We are recently getting ORA-04031 errors related shared pool so we are thinking of increasing the MEMORY_MAX_TARGET to 10GB (from 6 GB)

Here is our /dev/shm setting

SQL> host df -m |grep tmpfs

tmpfs                     7960      2847      5114  36% /dev/shm


2 questions:

1. How come we have the memory_max_target set to 6 GB but show sga shows the SGA to be 2.7 GB (does it mean that the rest of the memory 6GB  - 2.7 GB = 2.3 GB is allocated to other likes PGA etc?

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