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 -> Relate V$SQL.ROWS_PROCESSED/V$SYSSTAT.NAME='logical reads' ??

Relate V$SQL.ROWS_PROCESSED/V$SYSSTAT.NAME='logical reads' ??

From: Spendius <spendius_at_muchomail.com>
Date: 2 Jun 2005 06:47:26 -0700
Message-ID: <1117720046.433910.187010@f14g2000cwb.googlegroups.com> 





Hi,


Do you think it would make sense to get:
o at time t(1) the value of v$sql.rows_processed
  and that of v$sysstat.value for name='logical reads'
o then at time t(2) the same figures


o etc.


o then at time t(n) once again the same figures



then substract from the first values, compute an average
and be able to say "for this DB my overall rate of records
returned per block read is <result of the avg>" ?
Or is it complete rubbish ?



Thanks.
Received on Thu Jun 02 2005 - 08:47:26 CDT












Original text of this message













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