Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Buffer Cache Hit Ratio Discrepency
v$sysstats fields can overflow - if your database is busy and has been up for a long time, the value may sum to be too large for the field to handle it. I use the sum of all the file stats myself.
-- Wayne Linton lintonw_at_cadvision.comReceived on Thu Nov 20 1997 - 00:00:00 CST