select
THREAD#, -- THREAD# NUMBER
STATUS, -- STATUS VARCHAR2(6)
ENABLED, -- ENABLED VARCHAR2(8)
GROUPS, -- GROUPS NUMBER
INSTANCE, -- INSTANCE VARCHAR2(80)
OPEN_TIME, -- OPEN_TIME DATE
CURRENT_GROUP#, -- CURRENT_GROUP# NUMBER
SEQUENCE#, -- SEQUENCE# NUMBER
CHECKPOINT_CHANGE#, -- CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME, -- CHECKPOINT_TIME DATE
ENABLE_CHANGE#, -- ENABLE_CHANGE# NUMBER
ENABLE_TIME, -- ENABLE_TIME DATE
DISABLE_CHANGE#, -- DISABLE_CHANGE# NUMBER
DISABLE_TIME, -- DISABLE_TIME DATE
LAST_REDO_SEQUENCE#, -- LAST_REDO_SEQUENCE# NUMBER
LAST_REDO_BLOCK, -- LAST_REDO_BLOCK NUMBER
LAST_REDO_CHANGE#, -- LAST_REDO_CHANGE# NUMBER
LAST_REDO_TIME -- LAST_REDO_TIME DATE
from
GV$THREAD
where
inst_id = USERENV('Instance')