How do I determine the SGA size for my Oracle database?

Share

Tweet

Share

Share

Email

Comments

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

You can display the total SGA size by using the SQL statement.

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