Oracle PL/SQL/System Tables Views/V SGA

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>