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






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>








30.121.V_SGA
30.121.1.Display SGA area sizes.