modified on 8 April 2008 at 15:55 ••• 665 views

Datafile blocks per read

From Oramosswiki

Jump to: navigation, search
SELECT phyrds
,      phyblkrd
,      ROUND((phyblkrd / phyrds),2) blocks_per_read
FROM   (SELECT SUM(f.phyrds) phyrds
        ,      SUM(f.phyblkrd) phyblkrd
        FROM   v$filestat f
       )
/