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 ) |