SGA Size In Oracle

Onur ARDAHANLI

7 months ago

In today’s article, I will be explaining how we can learn the size of the SGA (System Global Area) in Oracle.

Size of SGA area;

1. We can find out while the database is opening.

2. We can learn the v$sgastat view from TOAD by querying it.

3. We can learn from Sql*Plus by querying the following query.

SQL> startup;

1	SQL> startup;

SQL> select POOL, NAME, BYTES from v$sgastat order by bytes desc;

1	SQL> select POOL, NAME, BYTES from v$sgastat order by bytes desc;