CACHED RESOURCES Page
In Manager, you access cache resources information by choosing Cached Resources from the MONITORING menu. The CACHED RESOURCES page is displayed, providing information about the cached views and procedures, both enabled and disabled, that are configured for use in TDV. Summary information is displayed at the top of the CACHED RESOURCES page, and information about each individual cache is displayed in the table.
Work with the CACHED RESOURCES Page
You can enable or disable cached tables and procedures and you can refresh them manually if necessary. Each row has a check box to selectively choose the cache you want to enable, disable, or refresh. After selecting the caches, you can click these buttons:
• Change Enabling—toggles the enabled/disabled status of selected caches. Changing of the Enabled status requires user to have the Modify All Status right.
• Refresh Cache(s)—refreshes the selected caches. Cache refresh requires that the user have the Write privilege on the selected resource.
• Clear Cache(s)—refreshes the selected caches. Cache refresh requires that the user have the Write privilege on the selected resource.
The CACHED RESOURCES Table
The CACHED RESOURCES table displays summary information with cache details available.
Name - the display name of the view or the procedure.
Status - Current status of the cached view. The status of a cached resource can be:
Status | Event |
NOT LOADED | Cache is configured, but it has not been loaded. |
UP | Cache has been loaded successfully. |
FAILED | Cache is not loaded and the most recent refresh failed. |
STALE | Cache is loaded with valid data, but the most recent refresh failed. Reads against the cache can succeed. If the status is STALE with an "All buckets are in use ..." message, you can clear the cache to get out of that status. |
DISABLED | Cache has been disabled. |
CONFIG ERROR | Cache cannot operate due to a configuration error. |
SETTINGS MISMATCH | This indicates a difference between the data source and TDV for the case sensitivity or trailing spaces settings. It is informational only and can be ignored. It indicates that the cache is available. |
Type - Values can be Table or Procedure.
Variant - Unique set of procedure input parameter values. Every set of procedure input parameters have a different storage table result set.
Owner - Resource owner. The cache is refreshed and cleared using the owner’s identity.
Last Access - Date and time of the last end-user invocation of a view or procedure, also includes last refresh of data by timer, or last change of metadata.
Last Refresh End - Completion date and time of last query refresh.
Last Fail End - Date and time when the last refresh attempt failed.
Storage Used - Disk space used to store result of table or procedure variant.
The IN PROGRESS REFRESHES Table
The IN PROGRESS REFRESHES table displays any cache resources that are in the process of being refreshed.
Cached Resource Details
Each row also has a Show Row Details button which you can use to display the fully qualified path and other details about cached resources.
Path - TDV resource location, fully qualified path.
Owner domain - domain of the user who created the resource, or who is currently designated as owner.
Total Accesses - count of the number of times the cache resource is used since last TDV restart.
Last Success End - Last successful completion date and time.
Last Success Duration - Time (seconds) required for last successful refresh.
Last Fail Duration - Time recorded for last failure.
Total Successes - Count of successful refreshes since last TDV restart.
Total Failures - Count of failed refreshes since last TDV restart.
Message - Error message returned from cache refresh failure.