Re: Buf Hit Ratio

2002-04-08 Thread Jonathan Lewis
Given that a 1 GHz CPU can do about 100,000 logical I/Os per second, and the largest machine is currently (I think) only 128 CPUs, I can only guess three possibilities: Your instance has been up for the last 500 years The statistics numbers don't match the ones that the Oracle code is supposed

RE: Buf Hit Ratio

2002-04-08 Thread DENNIS WILLIAMS
Glenn - V$SYSSTAT holds cumulative values since the instance was started. You need to measure it over a period of time. Note the values, then note them again in one hour, and measure the difference. Or use Oracle's utility STATSPACK or the older utlbstat/utlestat. Even better, get Oracle