摘要: 查看Oracle数据库命中率 1、查询Oracle数据字典缓存命中率: select (1-(sum(getmisses)/sum(gets))) * 100 "Hit Ratio" from v$rowcache; 2、查询Oracle的latch命中率: select 1-sum(misses) 阅读全文
posted @ 2020-09-23 09:57 da0h1 阅读(501) 评论(0) 推荐(0) 编辑
摘要: MySQL监控SQL状态及命中率 [root@hank-yoon scrips]# vi mysqlstat.sh/export/servers/mysql/bin/mysqladmin -P3306 -uyoon -pyoon -h127.0.0.1 -r -i 2 ext |\awk -F"|" 阅读全文
posted @ 2020-09-23 09:29 da0h1 阅读(173) 评论(0) 推荐(0) 编辑