Sep
23
2009
How to Calculate Hit Ratio from Tkprof output
Tkprof will have three fields in output
1. Disk
2. Query
3. Current
Generally hit ratio is calculated like as follows
Hit Ratio = 1 – (Physical Reads/Logical Reads)
Physical Reads = Sum (Disk)
Logical Reads = Sum (Query) + Sum (Current)
