Server Record_Cache Checkpoint
    Allows the database administrator to force the Record Cache
    Server (RCS) process to checkpoint all modified rows from cache
    back to the database.

1  –  Description

    When you use row caches, it is possible for a large number
    of database records to be modified in row cache areas. These
    modified records must be written to the physical database files
    on disk at various times, such as backing up or verifying
    the database, or when closing the database. The RMU Server
    Record_Cache Checkpoint command causes the RCS process to
    immediately write all modified records from all row cache areas
    back to the physical database files on disk.

    If there are a large number of modified records to be written
    back to the database, this operation can take a long time.

2  –  Format

  (B)0  RMU/Server Record_Cache Checkpoint root-file-spec

    Command Qualifier                  x Defaults
                                       x
    /[No]Log                           x Current DCL verify value
    /[No]Wait                          x /NoWait

3  –  Parameters

3.1  –  root-file-spec

    Specifies the database root file for which you want to checkpoint
    all modified rows.

4  –  Command Qualifiers

4.1  –  Log

    Log
    Nolog

    Specifies whether the processing of the command is reported to
    SYS$OUTPUT. Specify the Log qualifier to request log output and
    the Nolog qualifier to prevent it. If you specify neither, the
    default is the current setting of the DCL verify switch. (The DCL
    SET VERIFY command controls the DCL verify switch.)

4.2  –  Wait

    Wait
    Nowait

    Specifies whether the Oracle RMU operation completes right away
    (Nowait) or whether RMU waits for the record cache server to
    complete the checkpoint before returning to the user. The default
    is Nowait.