John Doed wrote : >From the DBM GUI I see my Data Cache is 99%-100% but my Catalog hit rate is >anywhere between 70%-85%. I tried increasing CAT_CACHE_SUPPLY significantly >but that actually lowered the hit rate average to the mid 70's (it was low >80's before).
>How do I get Catalog Cache hit rate to 100%? It is not always possible to increase the catalog hit rate, because some events require to empty the cache completely. One of this events is a transaction rollback, others are DDL statements executed in your session. If increasing the parameter CAT_CACHE_SUPPLY does not improve your hit rate, it seems that it's caused by your application profile. Regards, Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
