-ve values for Physical reads

[Subodh deshpande_1]

All,
When i queried v$filestat, i found 1ve values for the physical reads.

Can you please tell me what these -ve reads mean?

Regards
Subodh

[Peter Godron]

Hi,
do you mean negative values? Those are normally caused by out of range values (too high).

Please also read:
http://forums1.itrc.hp.com/service/forums/helptips.do?#33 on how to reward any useful answers given to your questions.

So far you have never awarded any points !

[Subodh deshpande_1]

SQL> desc v$filestat
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
PHYRDS NUMBER
PHYWRTS NUMBER
PHYBLKRD NUMBER
PHYBLKWRT NUMBER
SINGLEBLKRDS NUMBER
READTIM NUMBER
WRITETIM NUMBER
SINGLEBLKRDTIM NUMBER
AVGIOTIM NUMBER
LSTIOTIM NUMBER
MINIOTIM NUMBER
MAXIORTM NUMBER
MAXIOWTM NUMBER

The limit for Number datatype is 2^38 i guess, but i doubt if the physical reads are that high.

Regards
Subodh