VIEW: SYS.INT$DBA_HIST_THREAD

Source

View Text - Preformatted

select th.snap_id, th.dbid, th.instance_number,
       thread#, thread_instance_number, th.status,
       open_time, current_group#, sequence#,
       decode(th.con_dbid, 0, th.dbid, th.con_dbid),
       0 con_id
  from DBA_HIST_SNAPSHOT sn, WRH$_THREAD th
  where     sn.snap_id         = th.snap_id
        and sn.dbid            = th.dbid
        and sn.instance_number = th.instance_number

View Text - HTML Formatted

SELECT TH.SNAP_ID
, TH.DBID
, TH.INSTANCE_NUMBER
, THREAD#
, THREAD_INSTANCE_NUMBER
, TH.STATUS
, OPEN_TIME
, CURRENT_GROUP#
, SEQUENCE#
, DECODE(TH.CON_DBID
, 0
, TH.DBID
, TH.CON_DBID)
, 0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_THREAD TH
WHERE SN.SNAP_ID = TH.SNAP_ID
AND SN.DBID = TH.DBID
AND SN.INSTANCE_NUMBER = TH.INSTANCE_NUMBER