In the user menu Memory Areas, you can see, among other things, the sizes of the most important caches, the number of accesses to these caches, and the cache hit rates since the last time the Database Monitoring function was started.
1. In the Database Assistant, choose Current Status ® Memory Areas.
2. Choose Caches.
The system displays information about the general efficiency of the cache of the database instance.
In a balanced system, the hit rate for the data cache is more than 98%, more than 90% for the catalog cache and 100 % for the converter.
The lower the hit rate, the lower the efficiency of your database system.
Database Alert Monitor: Caches