DBA Data[Home] [Help]

VIEW: SYS.DBA_HIST_THREAD

Source

View Text - Preformatted

select "SNAP_ID","DBID","INSTANCE_NUMBER","THREAD#","THREAD_INSTANCE_NUMBER","STATUS","OPEN_TIME","CURRENT_GROUP#","SEQUENCE#","CON_DBID","CON_ID" from INT$DBA_HIST_THREAD
View Text - HTML Formatted

SELECT "SNAP_ID"
, "DBID"
, "INSTANCE_NUMBER"
, "THREAD#"
, "THREAD_INSTANCE_NUMBER"
, "STATUS"
, "OPEN_TIME"
, "CURRENT_GROUP#"
, "SEQUENCE#"
, "CON_DBID"
, "CON_ID"
FROM INT$DBA_HIST_THREAD