rmoff

io2.sql

/*
I/O read throughput, by minute

From  v$sysmetric_history

http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/dynviews_3084.htm#REFRN30344

Other metrics:

        METRIC_ID METRIC_NAME
        --------- ------------------------------------
             2093 Physical Read Total Bytes Per Sec
             2126 Physical Read Bytes Per Sec
             2145 I/O Megabytes per Second

*/

set pagesize 70

col metric_name for a34
col metric_unit for a24
col value for 9999999990.9
col value_MB for 9990.9
--break on begin_time skip 1

prompt
prompt
prompt Physical Read Total Bytes Per Sec
prompt =================================

select to_char(begin_time,'YYYY-MM-DD-HH24:MI:SS') as begin_time
--      , to_char(end_time,'YYYY-MM-DD-HH24:MI:SS') as end_time
        , value / 1024 / 1024 as value_MB
--      , metric_name
--      , metric_id
--      , value
--      , metric_unit
from v$sysmetric_history
where
-- lower(metric_name) like '%bytes%'
--metric_id in (2093,2126,2145)
metric_id = 2093
--and begin_time = to_date('2010-09-14-08:49:54','YYYY-MM-DD-HH24:MI:SS')
order by begin_time, metric_id
/

Create a free website or blog at WordPress.com.

%d bloggers like this: