select io.snap_id, io.dbid, io.instance_number,
nm.function_id, nm.function_name,
io.small_read_megabytes, io.small_write_megabytes,
io.large_read_megabytes, io.large_write_megabytes,
io.small_read_reqs, io.small_write_reqs,
io.large_read_reqs, io.large_write_reqs,
io.number_of_waits, io.wait_time,
decode(io.con_dbid, 0, io.dbid, io.con_dbid),
con_dbid_to_id(decode(io.con_dbid, 0, io.dbid, io.con_dbid)) con_id
from DBA_HIST_SNAPSHOT sn, WRH$_IOSTAT_FUNCTION io,
WRH$_IOSTAT_FUNCTION_NAME nm
where sn.snap_id = io.snap_id
and sn.dbid = io.dbid
and sn.instance_number = io.instance_number
and io.function_id = nm.function_id
and io.dbid = nm.dbid
SELECT IO.SNAP_ID
, IO.DBID
, IO.INSTANCE_NUMBER
,
NM.FUNCTION_ID
, NM.FUNCTION_NAME
,
IO.SMALL_READ_MEGABYTES
, IO.SMALL_WRITE_MEGABYTES
,
IO.LARGE_READ_MEGABYTES
, IO.LARGE_WRITE_MEGABYTES
,
IO.SMALL_READ_REQS
, IO.SMALL_WRITE_REQS
,
IO.LARGE_READ_REQS
, IO.LARGE_WRITE_REQS
,
IO.NUMBER_OF_WAITS
, IO.WAIT_TIME
,
DECODE(IO.CON_DBID
, 0
, IO.DBID
, IO.CON_DBID)
,
CON_DBID_TO_ID(DECODE(IO.CON_DBID
, 0
, IO.DBID
, IO.CON_DBID)) CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_IOSTAT_FUNCTION IO
,
WRH$_IOSTAT_FUNCTION_NAME NM
WHERE SN.SNAP_ID = IO.SNAP_ID
AND SN.DBID = IO.DBID
AND SN.INSTANCE_NUMBER = IO.INSTANCE_NUMBER
AND IO.FUNCTION_ID = NM.FUNCTION_ID
AND IO.DBID = NM.DBID
|
|
|