复制select substr(to_char(snap_time,中诊断yyyy-mm-ddHH24:MI:SS),12), (newreads.value-oldreads.value)reads, (newwrites.value-oldwrites.value)writes from perfstat.stats$sysstatoldreads, perfstat.stats$sysstatnewreads, perfstat.stats$sysstatoldwrites, perfstat.stats$sysstatnewwrites, perfstat.stats$snapshotsn where newreads.snap_id=sn.snap_id and newwrites.snap_id=sn.snap_id and oldreads.snap_id=sn.snap_id-1 and oldwrites.snap_id=sn.snap_id-1 and oldreads.statistic#=40 and newreads.statistic#=40 and oldwrites.statistic#=41 and newwrites.statistic#=41 and (newreads.value-oldreads.value)>0 and (newwrites.value-oldwrites.value)>0

select substr(to_char(snap_time,yyyy-mm-ddHH24:MI:SS),12), (newreads.value-oldreads.value)reads, (newwrites.value-oldwrites.value)writes from perfstat.stats$sysstatoldreads, perfstat.stats$sysstatnewreads, perfstat.stats$sysstatoldwrites, perfstat.stats$sysstatnewwrites, perfstat.stats$snapshotsn where newreads.snap_id=sn.snap_id and newwrites.snap_id=sn.snap_id and oldreads.snap_id=sn.snap_id-1 and oldwrites.snap_id=sn.snap_id-1 and oldreads.statistic#=40 and newreads.statistic#=40 and oldwrites.statistic#=41 and newwrites.statistic#=41 and (newreads.value-oldreads.value)>0 and (newwrites.value-oldwrites.value)>0 /1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.63.64.65.