Database Memory & 4030/4031 (MOSC)

MOSC Banner

I have total 64 Gig for, out of which we allocated 40gig for oracle SGA keeping below points, can yo

edited Jul 20, 2017 5:02AM in Database Memory & 4030/4031 (MOSC) 3 commentsAnswered

DB total we have 64GB, we have allocated 40GB for DB, hugepage setting has done. However when you check the usage it shows free memory zero.

18:19:54 # free -g

total used free shared buffers cached

SQL> show sga

Total System Global Area 4.0354E+10 bytes

Fixed Size 2273928 bytes

Variable Size 5905583480 bytes

Database Buffers 3.4427E+10 bytes

Redo Buffers 18984960 bytes

SQL> SELECT * FROM v$sga;

NAME VALUE

-------------------- ----------

Fixed Size 2273928

Variable Size 5905583480

Database Buffers 3.4427E+10

Redo Buffers 18984960

SQL> select * from v$sgainfo;

NAME BYTES RES

-------------------------------- ---------- ---

Fixed SGA Size 2273928 No

Redo Buffers 18984960 No

Buffer Cache Size 3.4427E+10 Yes

Shared Pool Size 5368709120 Yes

Tagged:

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