Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Buffer Cache Hit Ratio Discrepency

Re: Buffer Cache Hit Ratio Discrepency

From: <lintonw_at_cadvision.com>
Date: 1997/11/20
Message-ID: <3475139B.2873@cadvision.com>#1/1

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.com
Received on Thu Nov 20 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US