select
  THREAD#,                                 -- THREAD# NUMBER
  SEQUENCE#,                               -- SEQUENCE# NUMBER
  FIRST_CHANGE#,                           -- FIRST_CHANGE# NUMBER
  FIRST_TIME,                              -- FIRST_TIME DATE
  SWITCH_CHANGE#                           -- SWITCH_CHANGE# NUMBER
from
  GV$LOGHIST
where
  inst_id = USERENV('Instance')