Hi,
There are lot of ways by which you can do the health checkups of your database. You can calculate data hit ratio by querying the dictionary and make an analysis of your database usage. You can also check out the library hit ratio and the library cache access details, by which you will come to know about the access of your dictionary cache details.
Thanks & Regards,
DoubleH