../E40402-16.epub /> ../E40402-16.mobi />

DBA_HIST_THREAD

DBA_HIST_THREAD displays historical thread information from the control file.

Column Datatype NULL Description
SNAP_ID NUMBER NOT NULL Unique snapshot ID
DBID NUMBER NOT NULL Database ID for the snapshot
INSTANCE_NUMBER NUMBER NOT NULL Instance number for the snapshot
THREAD# NUMBER NOT NULL Thread number
THREAD_INSTANCE_NUMBER NUMBER   Instance number of the thread
STATUS VARCHAR2(6)   Thread status (OPEN) or (CLOSED)
OPEN_TIME DATE   Last time the thread was opened
CURRENT_GROUP# NUMBER   Current log group
SEQUENCE# NUMBER   Sequence number of the current log