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

sql> SHOW SGA;
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;

Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

To Top