1. Database Reference
  2. Dynamic Performance Views
  3. Dynamic Performance (V$) Views: V$SCHEDULER_RUNNING_JOBS to V$ZONEMAP_USAGE_STATS
  4. V$SGAINFO

9.37 V$SGAINFO

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 item is resizeable (Yes) or not (No)

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data