SQL Guide : Database system tables and system views : System tables : SYS_CACHESEGMENT_CONDITIONS
  
SYS_CACHESEGMENT_CONDITIONS
The SYS_CACHESEGMENT_CONDITIONS table contains information about the user-defined cache segments and the assignments of tables or data ranges to the segments.
Column name
Data type
Description
BASE_TABLE_ID
INTEGER
Internal identification number of the table with cache segment assignments
CACHE_SEGMENT_
NAME
WVARCHAR
Name of the cache segment to which the table or data range is assigned
COLUMN_NO
INTEGER
Internal identification number of the column with cache segment assignments
CONDITION
WVARCHAR
Type of range specification
Possible values are:
<
>
=
<>
BETWEEN ... AND
OLDERTHAN ... DAYS
OLDERTHAN ... SECONDS
NEWERTHAN ... DAYS
NEWERTHAN ... SECONDS
VALUE1
WVARCHAR
First value in the range specification
VALUE2
WVARCHAR
Second value in the range specification if CONDITION is BETWEEN
See also
System tables