Library /sys$common/syshlp/SQL$HELP_OLD72.HLB  —  CREATE  DATABASE  Arguments  ROW_CACHE
    Syntax options:

    ROW CACHE IS ENABLED | ROW CACHE IS DISABLED

    Specifies whether or not you want Oracle Rdb to enable the row
    caching feature.

    When a database is created or is converted from a previous
    version of Oracle Rdb without specifying row cache support, the
    default is ROW CACHE IS DISABLED. Enabling row cache support does
    not affect database operations until a row cache is created and
    assigned to one or more storage areas.

    When the row caching feature is disabled, all previously created
    and assigned row cache definitions remain in existence for future
    use when the row caching feature is enabled.

    The following conditions must be true in order to use row caches:

    o  The number of cluster nodes is one

    o  After-image journaling is enabled

    o  Fast commit is enabled

    o  One or more cache slots are reserved

    o  Row caching is enabled

    Use the RMU Dump Header command to check if you have met the
    requirements for using row caches. The following command output
    displays a warning for every requirement that is not met:

       .
       .
       .
    Row Caches...

    - Active row cache count is 0

    - Reserved row cache count is 1

    - Sweep interval is 1 second

    - Default cache file directory is ""

    - WARNING: Maximum node count is 16 instead of 1

    - WARNING: After-image journaling is disabled

    - WARNING: Fast commit is disabled
       .
       .
       .
Close Help