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