RIYOSU

select snap_id,begintime,endtime,filename,sum(Phy_Reads),sum(Phy_Read_Time),sum(Phy_Writes),sum(Phy_write_time) from
(select nm.snap_id,
  to_char(begin_interval_time,'DD-MON-YYYY HH24:MI') begintime,
  to_char(end_interval_time,'DD-MON-YYYY HH24:MI') endtime, filename,
nvl(decode(greatest(PHYBLKRD, nvl(lag(PHYBLKRD) over (partition by dba_hist_filestatxs.dbid,
dba_hist_filestatxs.instance_number, tsname, filename order by dba_hist_filestatxs.snap_id),0)),
PHYBLKRD, PHYBLKRD - lag(PHYBLKRD) over (partition by dba_hist_filestatxs.dbid, dba_hist_filestatxs.instance_number,
tsname, filename order by dba_hist_filestatxs.snap_id),PHYBLKRD), 0) Phy_Reads,
nvl(decode(greatest(READTIM, nvl(lag(READTIM) over (partition by dba_hist_filestatxs.dbid,
dba_hist_filestatxs.instance_number, tsname, filename order by dba_hist_filestatxs.snap_id),0)),
READTIM, READTIM - lag(READTIM) over (partition by dba_hist_filestatxs.dbid, dba_hist_filestatxs.instance_number,
tsname, filename order by dba_hist_filestatxs.snap_id),READTIM), 0) Phy_Read_Time,
nvl(decode(greatest(PHYBLKWRT, nvl(lag(PHYBLKWRT) over (partition by dba_hist_filestatxs.dbid,
dba_hist_filestatxs.instance_number, tsname, filename order by dba_hist_filestatxs.snap_id),0)),
PHYBLKWRT, PHYBLKWRT - lag(PHYBLKWRT) over (partition by dba_hist_filestatxs.dbid, dba_hist_filestatxs.instance_number,
tsname, filename order by dba_hist_filestatxs.snap_id),PHYBLKWRT), 0)  Phy_Writes,
nvl(decode(greatest(WRITETIM, nvl(lag(WRITETIM) over (partition by dba_hist_filestatxs.dbid,
dba_hist_filestatxs.instance_number, tsname, filename order by dba_hist_filestatxs.snap_id),0)), 
WRITETIM, WRITETIM - lag(WRITETIM) over (partition by dba_hist_filestatxs.dbid, dba_hist_filestatxs.instance_number, tsname,
filename order by dba_hist_filestatxs.snap_id),WRITETIM), 0) Phy_Write_Time
from
dba_hist_filestatxs,
dba_hist_snapshot nm
where
dba_hist_filestatxs.snap_id = nm.snap_id 
and begin_interval_time >= sysdate - 1
and filename like '%'
order by
nm.begin_interval_time) iodetail
group by snap_id,begintime,endtime,filename