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.