Part 4: The Connect XE Drivers : The Salesforce Driver : Catalog Tables : SYSTEM_CACHES Catalog Table

SYSTEM_CACHES Catalog Table
The SYSTEM_CACHES catalog table stores the definitions of the caches created on remote tables. The data in the SYSTEM_CACHES table provides the name, type (single table or relational), status, and other information for each defined cache. The table name returned for a remote relational cache is the name of the primary table of the relational cache; however, its type is REMOTE RELATIONAL. You can query SYSTEM_CACHES to determine the caches currently defined by the driver. The values in the SYSTEM_CACHES table are read-only. The referenced tables of a relational cache can be determined by querying the SYSTEM_CACHE_REFERENCES catalog table (see SYSTEM_CACHE_REFERENCES Catalog Table).
The following table describes the columns of the SYSTEM_CACHES table, which is sorted on the following columns: CACHE_TYPE, TABLE_SCHEMA, and TABLE_NAME.
The type cache, which can be either REMOTE TABLE or REMOTE RELATIONAL.
New: The cache has been created, but the data has not been populated.
Initialized: The cache has been created and the data has been populated.
Load aborted: The cache has been created, but the last attempt to populate the data failed. The cache is still valid. The next access attempts to populate the data again.
Invalid: The cache is invalid. The second attempt to populate the data failed.
Dirty: An insert or update operation has been performed on the cache and the cache has not been refreshed.

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.