Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Relate V$SQL.ROWS_PROCESSED/V$SYSSTAT.NAME='logical reads' ??
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
![]() |
![]() |