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

30. Display SGA area sizes.

   <source lang="sql">

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></source>