Re: Range of values for buffer_gets in stats$sql_summary

Vijay,

-ive values are generally due to wrap-around. Since STATSPACK data is just snapshots of V$ views, which in turn are cumulative, you will see this issue when your database has been up for a long time and the counter wraps around. In the case of STATS$SQL_SUMMARY, the BUFFER_GETS is derived from V$SQL.BUFFER_GETS. Negative values in buffer_gets may be seen in SQL that results in a lot of buffer gets *AND* is 'kept alive' in the lib cache via constant executions and pins. (I have one particular SQL that has this "issue" on an Oracle Apps 11i instance)

> What is the range of values for buffer_gets column in stats$sql_summary
> table. Our tables have -ve values in few cases.
>

-- 
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

Disappointment is always inevitable; Discouragement is invariably optional

** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **

--
http://www.freelists.org/webpage/oracle-l