How to Check SGA size in Oracle Database

Use below sql statements to check the SGA size of a Oracle Database.


sql> SHOW SGA;
or
sql> SELECT name,value/1024/1024 "SGA (MB)" "FROM v$sga;


You can check the Total SGA size from below sql statement.


sql> SELECT sum(value)/1024/1024 "TOTAL SGA (MB)" FROM v$sga;