Oracle Hit/Miss Ratios
来源:互联网 发布:php文件分享系统 编辑:程序博客网 时间:2024/04/30 02:15
Hit/Miss Ratios
Here are some scripts related to Hit/Miss Ratios .
Buffer Hit Ratio
BUFFER HIT RATIO NOTES:
select sum(decode(NAME, 'consistent gets',VALUE, 0)) "Consistent Gets",sum(decode(NAME, 'db block gets',VALUE, 0)) "DB Block Gets",sum(decode(NAME, 'physical reads',VALUE, 0)) "Physical Reads",round((sum(decode(name, 'consistent gets',value, 0)) + sum(decode(name, 'db block gets',value, 0)) - sum(decode(name, 'physical reads',value, 0))) / (sum(decode(name, 'consistent gets',value, 0)) + sum(decode(name, 'db block gets',value, 0))) * 100,2) "Hit Ratio"from v$sysstat
Data Dict Hit Ratio
DATA DICTIONARY HIT RATIO NOTES:
select sum(GETS),sum(GETMISSES),round((1 - (sum(GETMISSES) / sum(GETS))) * 100,2)from v$rowcache
SQL Cache Hit Ratio
SQL CACHE HIT RATIO NOTES:
select sum(PINS) Pins,sum(RELOADS) Reloads,round((sum(PINS) - sum(RELOADS)) / sum(PINS) * 100,2) Hit_Ratiofrom v$librarycache
Library Cache Miss Ratio
LIBRARY CACHE MISS RATIO NOTES:
select sum(PINS) Executions,sum(RELOADS) cache_misses,sum(RELOADS) / sum(PINS) miss_ratiofrom v$librarycache
- Oracle Hit/Miss Ratios
- Settings for Oracle Library Cache Reload andLibrary Cache Hit Ratios
- 1003: Hit or Miss
- 1003. Hit or Miss
- Hit-and-Miss Transform
- 1003 Hit or Miss
- hit-miss变换实例
- soj1003. Hit or Miss
- 1003. Hit or Miss
- CACHE的Miss和Hit
- Sicily 1003. Hit or Miss
- sicily--1003. Hit or Miss
- sicily 1003 Hit or Miss
- siciy 1003. Hit or Miss
- cache 读写 miss与hit
- sicily 1003. Hit or Miss
- Sicily 1003. Hit or Miss
- Hit-under-miss&&Return stack
- Linux配置java开发平台
- JDBC 笔记
- 影响最大的几本书
- 新的开始
- hibernate 笔记
- Oracle Hit/Miss Ratios
- pl_sql
- 十个以上串口加载问题-用CREATEFILE打开COM10
- 设计模式
- MM设计模式
- CSDN的第二天(浪漫七夕)
- Spring的IoC和DI最生动的解释
- 串行通信与重叠I/O
- MS SQL Server:分区表、分区索引详解