eygle.com - 留言簿 - 回复留言

eygle.com - 留言簿 - 回复留言 - Powered by eYgLe.Com

返回留言簿

回复留言

留言ID:

留言原文:

To: eygle
　　SQL> select TO_CHAR (snap_time,'yyyy-mm-dd HH24:MI:SS') snap_time,
 SUBSTR (TO_CHAR (snap_time,'yyyy-mm-dd HH24:MI:SS'),12) TIME,
 (newreads.VALUE - oldreads.VALUE) READS,
 (newwrites.VALUE - oldwrites.VALUE) WRITES
from perfstat.stats$sysstat oldreads,
 perfstat.stats$sysstat newreads,
 perfstat.stats$sysstat oldwrites,
 perfstat.stats$sysstat newwrites,
 perfstat.stats$sysstat sn
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.NAME='physical reads'
 and newreads.NAME='physical reads'
 and oldwrites.NAME='physical writes'
 and newwrites.NAME='physical writes'
 and (newreads.VALUE - oldreads.VALUE)>0
 and (newwrites.VALUE - oldwrites.VALUE)>0
/

From: javen
2009.11.25 20:14