This view lists data about all redo threads for all incarnations of the database since the last catalog resynchronization. This view corresponds to V$THREAD.
The primary key for the target database. Use this column to join with almost any other catalog view.
The primary key for the incarnation of the target database. Use this column to join with RC_DATABASE_INCARNATION.
The DB_NAME of the database incarnation to which this record belongs.
The redo thread number for the database incarnation.
The status of the redo thread: D (disabled), E (enabled), or O (open).
The last allocated log sequence number.
The SCN at which this thread was enabled.
The time at which this thread was enabled.
The most recent SCN at which this thread was disabled. If the thread is still disabled, then no redo at or beyond this SCN exists for this thread. If the thread is now enabled, then no redo exists between the DISABLE_CHANGE# and the ENABLE_CHANGE# for this thread.
The most recent time at which this thread was disabled.