Library /sys$common/syshlp/SQL$HELP72.HLB  —  ALTER  DATABASE  Arguments  SWEEP_INTERVAL
    Syntax option:

    SWEEP INTERVAL IS n SECONDS

    Specifies the interval, in seconds, between each Record Cache
    Server (RCS) sweep. Allowable values must be in the range from 1
    second to 3600 seconds (1 hour). The default is 1.

    The Record Cache Server (RCS) is a detached server process
    automatically invoked by the monitor when row caching is active.

    A sweep is one full pass through all active row cache areas to
    write modified rows back to the database storage areas.
Close Help