VMS Help  —  SQL72  Information Tables, RDB$CACHES
    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
Additional Information: explode extract
RDB$FLAGS
Close Help