V$SGAINFO displays size information about the SGA, including the sizes of different SGA items, the granule size, and free memory.
| Column | Datatype | Description |
|---|---|---|
NAME |
VARCHAR2(32) |
Name of the SGA size item |
BYTES |
NUMBER |
Size of the item (in bytes) |
RESIZEABLE |
VARCHAR2(3) |
Indicates whether the statistic is resizeable (Yes) or not (No) |