-
I ran the following scripts..
SELECT parameter, gets, Getmisses,
getmisses/(gets+getmisses)*100 "Miss Ratio",
(1-(sum(getmisses)/ (sum(gets)+sum(getmisses))))*100 "Hit Ratio"
FROM v$rowcache
WHERE gets+getmisses <>0
GROUP BY parameter, gets, getmisses;
and I got the following results...
Miss Ratio Hit Ratio
---------- ---------
20 80
1.25 98.75
19.13 80.87
.9925 99.01
24.99 75.01
1.058 98.94
.3995 99.6
8.012 91.99
23.08 76.92
26.32 73.68
17.49 82.51
33.33 66.67
.6425 99.36
.5745 99.43
3.448 96.55
.377 99.62
Can you explain what's going on with the results?....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|