Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Physical block reads difference

Physical block reads difference

From: Jayaraman Ashok <ashok_jayaraman_at_yahoo.com>
Date: 26 Sep 2002 03:21:51 -0700
Message-ID: <7ca2852.0209260221.37be8227@posting.google.com> 





Hi


I queried the v$sysstat for getting the 'physical reads' on the
database. I believe this is the number of physical block reads. Now
querying the sum(phyblkrds) in v$filestat, shouldn't the value be the
same? I think both the statsistics are one and the same. But then why
the difference? Kindly explain.



Cheers,


Ashok
Received on Thu Sep 26 2002 - 05:21:51 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US