Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Display SGA area sizes

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>