cancel
Showing results for 
Search instead for 
Did you mean: 

-ve values for Physical reads

-ve values for Physical reads

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
2 REPLIES
Peter Godron
Honored Contributor

Re: -ve values for Physical reads

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 !

Re: -ve values for Physical reads

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