VIEW: SYS.INT$DBA_HIST_SESS_TIME_STATS

Source

View Text - Preformatted

select st.snap_id, st.dbid, st.instance_number, st.session_type,
       st.min_logon_time, st.sum_cpu_time, st.sum_sys_io_wait,
       st.sum_user_io_wait,
       decode(st.con_dbid, 0, st.dbid, st.con_dbid),
       st.session_module,
       con_dbid_to_id(decode(st.con_dbid, 0, st.dbid, st.con_dbid)) con_id
  from DBA_HIST_SNAPSHOT sn, WRH$_SESS_TIME_STATS st
  where    st.snap_id           = sn.snap_id
      and  st.dbid              = sn.dbid
      and  st.instance_number   = sn.instance_number

View Text - HTML Formatted

SELECT ST.SNAP_ID
, ST.DBID
, ST.INSTANCE_NUMBER
, ST.SESSION_TYPE
, ST.MIN_LOGON_TIME
, ST.SUM_CPU_TIME
, ST.SUM_SYS_IO_WAIT
, ST.SUM_USER_IO_WAIT
, DECODE(ST.CON_DBID
, 0
, ST.DBID
, ST.CON_DBID)
, ST.SESSION_MODULE
, CON_DBID_TO_ID(DECODE(ST.CON_DBID
, 0
, ST.DBID
, ST.CON_DBID)) CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_SESS_TIME_STATS ST
WHERE ST.SNAP_ID = SN.SNAP_ID
AND ST.DBID = SN.DBID
AND ST.INSTANCE_NUMBER = SN.INSTANCE_NUMBER