Oracle PL/SQL Tutorial/System Tables Data Dictionary/V SGA

30. Display SGA area sizes.

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>