Negative values from v$rowcache and v$librarycache

From: Carlos Alberto <calberto2312_at_hotmail.com>
Date: 14 Oct 2002 09:24:49 -0700
Message-ID: <72954535.0210140824.18cbc4f7@posting.google.com>

Hi all,

I am monitoring the performance of Library Cache and Dictionary Cache, and then I need to read v$rowcache and v$librarycache. I´ve run these statements :

select sum(pins), sum(reloads), 100*(sum(reloads)/sum(pins)) from v$librarycache;

SUM(PINS) SUM(RELOADS) 100*(SUM(RELOADS)/SUM(PINS))
---------- ------------ ----------------------------
-788551512 371027 -,04705171

select sum(gets), sum(getmisses), 100*(sum(getmisses)/sum(gets)) from v$rowcache;

SUM(GETS) SUM(GETMISSES) 100*(SUM(GETMISSES)/SUM(GETS))
---------- -------------- ------------------------------

 -92174652         160333                     -,17394478

Why are SUM(PINS) and SUM(GETS) values are negative? I´m using Oracle 8.1.7.0.1 on Linux.

Thanks in advanced,
Carlos Received on Mon Oct 14 2002 - 11:24:49 CDT