Database Administration (MOSC)

MOSC Banner

Confusion with SGA size being allocated

edited Aug 5, 2020 5:00AM in Database Administration (MOSC) 4 commentsAnswered

I'm using Oracle Databse 19c on RHEL 7

I have set:

SGA_MAX_SIZE=9G

SGA_TARGET=9G

I am using Hugepages (transparent hugepages are disabled).

Oracle, on startup, in the alert log says:

EXPECTED_PAGES =  4610

and

Expected per process system memlock (soft) limit to lock instance MAX SHARED GLOBAL AREA (SGA) into memory: 9220M

Why is it 9220M?

SGA = 9G which is 9 * 1024 = 9216 MB

Why does Oracle calculate 9220M when I calculate 9216M ?

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