Re: Negative values from v$rowcache and v$librarycache

calberto2312_at_hotmail.com (Carlos Alberto) wrote in news:72954535.0210140824.18cbc4f7_at_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
>

I bet your running a 32-bit version of Oracle. If so the largest positive value Oracle can count is (2**31)-1, about 2GB. I suspect your instance has been up a while and the counters just rolled the highest order bit to being set; which is interpreted as a negative value.

HTH & YMMV HAND! Received on Mon Oct 14 2002 - 19:06:28 CDT