Caches

In the Performance display of the Database Alert Monitor, you can find, among other things, information about the cache hit rates.

Prerequisites

Prerequisites

Procedure

       1.      Start the Database Alert Monitor.

       2.      Choose <Name of the database connection> ® Performance ® Monitor.

Result

Display

Default for Alerts

Data Cache Hit Rate - total

Yellow alert, if the hit rate falls below 99%
Red alert, if the hit rate falls below 98 %

Catalog Cache Hit Rate

Yellow alert, if the hit rate falls below 80 %
Red alert, if the hit rate falls below 60 %

See also:

Displays in the Database Assistant: Caches