Database Memory & 4030/4031 (MOSC)

MOSC Banner

Oracle database server: calculate RAM for OS, database[SGA, PGA], HugePages`

edited Aug 11, 2016 5:00AM in Database Memory & 4030/4031 (MOSC) 5 commentsAnswered

Dear community ,

Can you advice me how to identify how much memory should I leave for OS?

How to distribute SGA and PGA sizes?

What should I set vm.nr_hugepages parameter not to make database server to have an out of memory.

My opinion: for OS  5%RAM should be left.

from 95%RAM 80% should be for SGA and 20% for PGA.

vm.nr_hugepages parameter should be set total number of SGA sizes(in case you have multiple DBs)  / Hugepagesize

Am I correct?

This is for initial installation (after monitoring memory usage we may change SGA PGA)

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center