Table level cache list screen

Any modifications made in this screen are temporary. If the applicable server is restarted, the changes made in this screen are lost.

If you need to permanently enable, disable, or change the cache limit for a specific database table, then you must override the dbclassCache.properties settings by adding the required entries in the <INSTALL_DIR>/properties/customer_overrides.properties file.

This screen enables viewing and modifying cache information at a table level for a particular server (application server, agent server, or integration server). For additional information about viewing application server cache information, refer to Viewing application server cache information. When you perform a modifying action in this screen, such as enable, disable, clear, or modify limit, the cache is modified only for the individual server that you are currently viewing.

Table 1. Table level cache list
Field	Description
Class	The name of the class corresponding to one database table.
Enabled	The check box within this field is checked when caching is enabled for this database table.
Cache Limit	The maximum number of objects that are cached for this database table.
Logical Reads	The number of reads that were successfully retrieved from the cache.
Physical Reads	The number of reads that were not retrieved from the cache.
Hit Ratio	The hit ratio indicates how well the caching is working for this database table. Ideally, the cache ratio should be close to 1. If the cache ratio is close to 0, then the objects being cache are not being accessed frequently. This number is calculated by taking the total number of logical reads and dividing it by the total number of all reads (logical and physical).
# Of Selects	The number of select clauses being cached.
# Of Lists	The number of list clauses being cached.
Cache Clear Count	The number of times cache was cleared for this table. Frequent cache clears could reflect some problem with the access being made to this table.
Objects Cached	The total number of objects currently in the cache.
Action	Description
Enable Cache	To enable caching on a specific database table, select the appropriate database class and click this button. This action is only enabled when caching is disabled for the selected table.
Disable Cache	To disable caching on a specific database table, select the appropriate database class and click this button. This action is only enabled when caching is enabled for the selected table.
Clear Cache	To clear the cache memory for a specific database table, select the appropriate database class and click this button.
Modify Cache Limit	To modify the cache limit for a specific database table, select the appropriate database class and click this button. Enter the new cache limit in the dialog and click OK.
Close	Click to close the window.