Oracle database table space last 2 hours of IO statistics

Select E.tsname tsname, sum (E.PHYRDS-NVL (b.phyrds, 0)) reads, SUM (E.PHYRDS-NVL (b.phyrds, 0)) (SELECT EXTRACT (Day from E.end_interval_time-b.end_interval_time) * 86400 + EXTRA CT (HOUR from E.end_interval_time-b.end_interval_time) * 3600 + EXTRACT (MINUTE from E.end_interval_time  
          -b.end_interval_time) * + EXTRACT (SECOND from E.end_interval_time-b.end_interval_time) From Dba_hist_snapshot B, dba_hist_snapshot E where b.snap_id = (select snap_id from Dba_hist_snapshot where en D_interval_time >sysdate-3/24 and End_interval_time <sysdate-2/24 and rownum<2) and E.SNAP_ID = (sel ECT snap_id from Dba_hist_snapshot where End_interval_time > Sysdate-1/24 and rownum<2) and b.startup_t IME = E.startup_time and B.end_interval_time < E.end_interval_time) RPS, decode (SUM (E.PHYRDS-NV  
     L (b.phyrds, 0)),         0, 0, * (SUM (E.READTIM-NVL (b.readtim, 0))/SUM (e.phyrds-n  
              VL (b.phyrds, 0))) ATPR, decode (SUM (E.PHYRDS-NVL (b.phyrds, 0)), 0, 0, Sum (E.PHYBLKRD-NVL (B.PHYBLKRD, 0))/sum (E.PHYRDS-NVL (b.phyrds, 0)) BPR, sum (e.phywrt S-NVL (b.phywrts, 0)) writes, SUM (E.PHYWRTS-NVL (b.phywrts, 0))/(SELECT EXTRACT (Day from E.end_inter Val_time-b.end_interval_time) * 86400 + EXTRACT (HOUR from E.end_interval_time-b.end_  
               Interval_time) * 3600 + EXTRACT (MINUTE from E.end_interval_time-b.end_interval_time) * 60 + EXTRACT (SECOND from E.end_interval_time-b.end_interval_time) from Dba_hist_snapshot B, DBA_HIST_SNAPSH OT E where b.snap_id = (select snap_id from Dba_hist_snapshot where End_interval_time >sysdate-3/24 and End_ Interval_time <sysdatE-2/24 and rownum<2) and e.snap_id = (select snap_id from Dba_hist_snapshot where End_interval_time > S YSDATE-1/24 and rownum<2) and b.startup_time = E.startup_time and B.end_interval_time < E. end_interval_time) WPS, SUM (E.WAIT_COUNT-NVL (b.wait_count, 0)) waits, decode (sum (E.WAIT_COUNT-NVL) (b.  
              Wait_count, 0)), 0, 0, * (SUM (E.TIME-NVL (b.time, 0))/ Sum (E.WAIT_COUNT-NVL (b.wait_count, 0))) ATPWT, sum (E.PHYRDS-NVL (b.phyrds, 0)) + SUM (e.phywrts-n VL (B.phywrts, 0)) iOS from Dba_hist_filestatxs E, Dba_hist_filestatxs b where b.snap_id = (select snap_id from Dba_ Hist_snapshot where End_interval_time >sysdate-3/24 and End_interval_time <sysdate-2/24 and rownum<2) and E. snap_id = (select snap_id from Dba_hist_snapshot where End_interval_time > sysdate-1/24) and Rownum<2 D = e.dbid and b.inStance_number = E.instance_number and B.tsname = e.tsname and b.file# = e.file# and b.creation_change# = e.  
creation_change# and (E.PHYRDS-NVL (b.phyrds, 0)) + (E.PHYWRTS-NVL (b.phywrts, 0)) > 0 Group by E.tsname UNION ALL select E.tsname tsname, sum (E.PHYRDS-NVL (b.phyrds, 0)) reads, SUM (E.PHYRDS-NVL (b.phyrds, 0  
               )/(SELECT EXTRACT (Day from E.end_interval_time-b.end_interval_time) * 86400 + EXTRACT (HOUR from E.end_interval_time-b.end_interval_time) * 3600 + EXTRACT (MINUTE from E.end_inter  
          Val_time-b.end_interval_time) * + EXTRACT (SECOND from E.end_interval_time-b.end_interval_time)  From Dba_hist_snapshot B, dba_hist_snapshot E WHERE b.snap_id = (select snap_id from Dba_hist_snapshot where End_interval_time >sysdate-3/24 and End_interval_time <sysdate-2/24 and rownum<2) and E.SNAP_ ID = (Select snap_id frOm dba_hist_snapshot where end_interval_time > Sysdate-1/24 and rownum<2) and B.end_interval_time <  
              E.end_interval_time) RPS, decode (SUM (E.PHYRDS-NVL (b.phyrds, 0)), 0, 0, (Sum (E.READTIM-NVL (b.readtim, 0))/sum (E.PHYRDS-NVL (b.phyrds, 0)) ATPR, decod E (SUM (E.PHYRDS-NVL (b.phyrds, 0)), 0, To_number (NULL), SUM (e.phyblkrd-n VL (B.PHYBLKRD, 0))/sum (E.PHYRDS-NVL (b.phyrds, 0)) BPR, sum (E.PHYWRTS-NVL (b.phywrts, 0)) WR Ites, SUM (E.PHYWRTS-NVL (b.phywrts, 0))/(SELECT EXTRACT (Day from E.end_interval_time-b.end_interval  
               _time) * 86400 + EXTRACT (HOUR from E.end_interval_time-b.end_interval_time) * 3600 +  EXTRACT (MINUTE from E.end_interval_time-b.end_interval_time) * + EXTRACT (SECOND from E.end_interval_time-b. End_interval_time) from Dba_hist_snapshot B, dba_hist_snapshot E WHERE b.snap_id = (select snap_id  
           From Dba_hist_snapshot where End_interval_time >sysdate-3/24 and End_interval_time <sysdate-2/24 and ROWNUM&LT;2) and e.snap_id = (select snap_id from Dba_hist_snapshot where End_interval_time > Sysdate-1/24 and Rownum&lt  
       2) and b.startup_time = E.startup_time and B.end_interval_time < E.end_interval_time) WPS,  
              Sum (E.WAIT_COUNT-NVL (b.wait_count, 0)) waits, decode (sum (E.WAIT_COUNT-NVL (b.wait_count, 0)), 0, 0, (SUM (E.TIME-NVL (b.time, 0))/sum (E.WAIT_COUNT-NVL (B.wai  
  T_count, 0)) ATPWT, sum (E.PHYRDS-NVL (b.phyrds, 0)) + SUM (E.PHYWRTS-NVL (b.phywrts, 0)) iOS From Dba_hist_tempstatxs E, Dba_hist_tempstatxs b where b.snap_id = (select snap_id from Dba_hist_snapshot where end_i Nterval_time >sysdate-3/24 and End_interval_time <sysdate-2/24 and rownum<2) and e.snap_id = (select snap_id from Dba_hist_snapshot where End_interval_time > Sysdate-1/24 and rownum<2) and b.dbid = e.dbid and B.instance_number = E.instanc  E_number and b.tsname = e.tsname and b.file# = e.file# and b.creation_change# = e.creation_change# and ((E.PHYRDS-NVL (b.phyrds, 0)) + (E.PHYWRTS-NVL (b.phywrts, 0)) > 0 Group by E.tsname ORDER by iOS desc, Tsnam E

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/