Library /sys$common/syshlp/SQL$HELP72.HLB  —  CREATE  STORAGE_AREA, Arguments  CACHE USING row cache name
    Assigns the named row cache to the specified storage area. All
    rows stored in this area, whether they consist of table data,
    segmented string data, or special rows such as index nodes, are
    cached if those rows fit in the cache.

    If the row cache does not exist, you must create the row cache
    before terminating the CREATE DATABASE statement. For example:

    SQL> CREATE DATABASE FILENAME test_db
    cont> ROW CACHE IS ENABLED
    cont> CREATE STORAGE AREA area1
    cont>    CACHE USING test1
    cont> CREATE CACHE test1
    cont>    CACHE SIZE IS 100 ROWS
    cont>    ROW LENGTH IS 200 BYTES;

    Only one row cache is allowed for each storage area.

    NO ROW CACHE is the default for a storage area.
Close Help