Database Tuning (MOSC)

MOSC Banner

Memory_max_target and Linux HugePages

edited Aug 18, 2011 8:43PM in Database Tuning (MOSC) 7 commentsAnswered ✓
Hi,

We are reviewing the memory usage of one of our 11.2.0.2 Oracle Databases, and I am trying to undestand the relationsheep between memory_max_target and Huge_Pages.

We use this machine only to run an Oracle Database with ASM: My actual setup,:

$ df -k /dev/shm

Filesystem           1K-blocks      Used Available Use% Mounted on
tmpfs                 16474536   7041700   9432836  43% /dev/shm

SQL> show parameter memory

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
memory_max_target                    big integer 12G
memory_target                        big integer 10G

I will make the folowwing asumptions:

- In this scenario we can increase the memory_max_target until reach the 16 Gbytes defined for the "/dev/shm" (MOS ID.460506.1).

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