Displays information about the database row caches.

                                Data
    Column Name                 Type      Description

    RDB$ALLOCATION              integer   Allocation
    RDB$EXTENT                  integer   Extent
    RDB$CACHE_ID                integer   Cache ID
    RDB$FLAGS                   integer   Flags
    RDB$ROW_LENGTH              integer   Row length
    RDB$CACHE_SIZE              integer   Cache size
    RDB$WINDOW_COUNT            integer   Window count
    RDB$NUM_RESERVED_ROWS       integer   Number of reserved rows
    RDB$NUM_SWEEP_ROWS          integer   Number of sweep rows
    RDB$CACHE_NAME              char(31)  Cache name
    RDB$LOCATION                char(255) Cache location
    RDB$SNAP_CACHE_SIZE         integer   Number of snapshot record
                                          slots in cache
    RDB$PHYSICAL_MEMORY         bigint    Physical memory in bytes

1  –  RDB$FLAGS

    Represents flags for RDB$CACHES information table.

    Bit
    Position   Description

    0          Shared memory is system
    1          Large memory is enabled
    2          Row replacement is enabled
    3          Device/directory is defined
    4          Updated rows to database
    5          Updated rows to backing file
    6          All rows to backing file
    7          Snapshots are enabled