Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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.
1 | SQL> startup; |
1 | SQL> select POOL, NAME, BYTES from v$sgastat order by bytes desc; |
