DBA Data[Home] [Help]

VIEW: SYS.V_$THREAD

Source

View Text - Preformatted

select "THREAD#","STATUS","ENABLED","GROUPS","INSTANCE","OPEN_TIME","CURRENT_GROUP#","SEQUENCE#","CHECKPOINT_CHANGE#","CHECKPOINT_TIME","ENABLE_CHANGE#","ENABLE_TIME","DISABLE_CHANGE#","DISABLE_TIME","LAST_REDO_SEQUENCE#","LAST_REDO_BLOCK","LAST_REDO_CHANGE#","LAST_REDO_TIME","CON_ID" from v$thread
View Text - HTML Formatted

SELECT "THREAD#"
, "STATUS"
, "ENABLED"
, "GROUPS"
, "INSTANCE"
, "OPEN_TIME"
, "CURRENT_GROUP#"
, "SEQUENCE#"
, "CHECKPOINT_CHANGE#"
, "CHECKPOINT_TIME"
, "ENABLE_CHANGE#"
, "ENABLE_TIME"
, "DISABLE_CHANGE#"
, "DISABLE_TIME"
, "LAST_REDO_SEQUENCE#"
, "LAST_REDO_BLOCK"
, "LAST_REDO_CHANGE#"
, "LAST_REDO_TIME"
, "CON_ID"
FROM V$THREAD