CREATE CACHE <row-cache-name> -+-+----------------------+-+-> | +-> row-cache-params1 -+ | | +-> row-cache-params2 -+ | +------------ <------------+ add-row-cache-clause = ---> ADD CACHE <row-cache-name> -+-+----------------------+-+-> | +-> row-cache-params1 -+ | | +-> row-cache-params2 -+ | +-------------<------------+ row-cache-params1 = --+-> ALLOCATION IS <n> -+--+-----------+----------------+-> +-> EXTENT IS <n> -----+ +-> BLOCK --+ | | +-> BLOCKS -+ | +-> CACHE SIZE IS <n> -+----> ROW --+------------------+ | +----> ROWS -+ | +-> CHECKPOINT -+> UPDATED ROWS TO -+> BACKING FILE -+-+ | | +> DATABASE -----+ | | +> ALL ROWS TO BACKING FILE ---------+ | +-> LARGE MEMORY IS ----+-+-> ENABLED --+--------------+ +-> ROW REPLACEMENT IS -+ +-> DISABLED -+ | +-> LOCATION IS --> <directory-spec> ------------------+ +-> NO LOCATION ---------------------------------------+ row-cache-params2 = --+-> NUMBER OF -+-> RESERVED -+-> ROWS IS <n> --------------+-> | +-> SWEEP ----+ | +-> ROW LENGTH IS <n> -+-------------+---------------------+ | +----> BYTE --+ | | +----> BYTES -+ | | | +-> ROW SNAPSHOT IS --+-> ENABLED rs-opt -+---------------+ | +-> DISABLED --------+ | | | +-> SHARED MEMORY IS --+----> SYSTEM -------------------+--+ +----> PROCESS --+-------------+-+ | | +-> RESIDENT -+ rs-opt = --+-------------------------------+---> +-> (CACHE SIZE IS <n> ROWS) ---+