I have total 64 Gig for, out of which we allocated 40gig for oracle SGA keeping below points, can yo
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