SQL$HELP72.HLB  —  CREATE  CACHE  Arguments  NUMBER_OF_RESERVED_ROWS
    Syntax options:

    NUMBER OF RESERVED ROWS IS n

    Specifies the maximum number of cache rows that each user can
    reserve for insertion into the cache. Processes reserve, or
    allocate, entries in a cache to be used when inserting rows into
    the cache. To improve efficiency, multiple entries are reserved
    at one once. Once a user's reserved list becomes depleted, Oracle
    Rdb attempts to reserve another group of entries. The default is
    20 rows.

    This value is also used when searching for available slots in a
    row cache. The entire row cache is not searched on the initial
    pass. This value specifies the maximum number of rows that are
    searched for a free slot. If at least one free slot is found, the
    insert operation can proceed. If no free slots are found in this
    initial search, Oracle Rdb continues searching through the cache
    until it finds a free slot.
Close Help