select
  THREAD#,                                 -- THREAD# NUMBER
  LOW_SEQUENCE#,                           -- LOW_SEQUENCE# NUMBER
  HIGH_SEQUENCE#                           -- HIGH_SEQUENCE# NUMBER
from
  GV$ARCHIVE_GAP
where
  inst_id = USERENV('Instance')