In general, it's desirable and recommended to have a high data hit ratio (80% or higher) and to have very high index hit ratio (90% or higher).
通常,推荐一个较高的数据命中率(80%或更高)和一个相当高的索引命中率(90%或更高),这也是最理想的。
Obviously, with availability of physical memory on the database server, a high buffer pool hit ratio is always better for your database performance.
显然,随着数据库服务器上物理内存的使用,高缓冲池命中率对于您的数据库性能而言始终比较好。
Check that the cache size is sufficiently large and that the cache hit ratio is high for each of the dynamic SQL statements being executed.
对于每个被执行的动态sql语句,请检查高速缓存是否足够大且高速缓存的命中率是否较高。
应用推荐