Display SGA area sizes. : V_SGA « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. V_SGA

SQL>
SQL>
SQL> select Name, Value
  2    from V$SGA;



NAME                       VALUE
--------------------  ----------
Fixed Size               1287016
Variable Size          104860824
Database Buffers       176160768
Redo Buffers             2904064

4 rows selected.

SQL>
SQL>