Reference Guide > TDV and Business Directory System Tables > SYS_CACHES
 
SYS_CACHES
The SYS_CACHES system table provides a list of all cached resources and their current status.
Users see no rows unless they have the ACCESS_TOOLS right. If they have this right, they see rows for all resources for which they have the READ privilege. Users with both ACCESS_TOOLS and READ_ALL_STATUS rights can see all rows.
Column
TDV
JDBC Data Type
Nullable
Description
RESOURCE_ID
INTEGER
 
The cached resource ID.
RESOURCE_NAME
VARCHAR(255)
 
The cached resource name.
RESOURCE_TYPE
VARCHAR(255)
 
The cached resource type. Can be TABLE or PROCEDURE.
OWNER_ID
INTEGER
 
The cached resource owner’s user ID.
OWNER
VARCHAR(255)
 
The cached resource owner’s name.
PARENT_PATH
VARCHAR(65535)
 
The path to the cached resource.
STATUS
VARCHAR(20)
 
The status of the cache. Value can be:
DISABLED—The cache is disabled.
NOT LOADED—The cache is enabled, but not loaded.
UP—The cache is enabled and loaded.
STALE—The cache is enabled and loaded, but the data has expired
DOWN—The cache failed its most recent attempt to load
CONFIG ERROR—The cache is not configured properly
VARIANT
VARCHAR(255)
Yes
NULL for TABLE views. NULL if no PROCEDURE variants are being tracked.
For a PROCEDURE, a comma-separated list of parameter values submitted for generation of the cache.
LAST_REFRESH_END
TIMESTAMP
Yes
The time the most recent refresh finished.
LAST_SUCCESS_END
TIMESTAMP
Yes
The time the most recent successful refresh finished.
LAST_FAIL_END
TIMESTAMP
Yes
The time the most recent failed refresh finished.
LAST_ACCESS
TIMESTAMP
Yes
The time the cache was most recently read from.
LAST_SUCCESS_DURATION
BIGINT
 
The number of milliseconds the most recent successful refresh took to complete.
LAST_FAIL_DURATION
BIGINT
 
The number of milliseconds the most recent failed refresh took to complete.
NUM_SUCCESS
INTEGER
 
The number of times the cache was successfully refreshed since the server was started.
NUM_FAIL
INTEGER
 
The number of times the cache failed to refresh since the server was started.
NUM_ACCESS
INTEGER
 
The number of times the cache was accessed for read since the server was started.
STORAGE_USED
BIGINT
 
The approximate byte size of the cache data.
MESSAGE
VARCHAR(65535)
Yes
A failure message if the cache is in an error state. NULL if there is no message.
INITAL_TIME
TIMESTAMP
Yes
The time the trigger is configured to first start. NULL if not condition type TIMER.
NEXT_TIME
TIMESTAMP
Yes
The time the trigger will next fire. NULL if not condition type TIMER.
FREQUENCY
VARCHAR(255)
Yes
Human-readable description of the frequency of the trigger. NULL if not condition type TIMER.
CURRENT_REFRESH_START
TIMESTAMP
Yes
The time the current in-progress refresh started. NULL if not currently refreshing.
CURRENT_DURATION
BIGINT
Yes
The number of milliseconds the in-progress refresh has been running. NULL if not currently refreshing.
CURRENT_STORAGE
BIGINT
Yes
The approximate byte size of the cache data currently being refreshed. NULL if not currently refreshing.
CURRENT_CAUSE
VARCHAR(20)
Yes
The reason the cache is refreshing. NULL if not currently refreshing. Can be MANUAL, SCHEDULED, EXPIRED, or ON_DEMAND.