V$LOBSTAT definition in Oracle Database 11.2
V$LOBSTAT

select
  inst_id,                                 -- INST_ID NUMBER
  LOBTSN,                                  -- LOBTSN NUMBER
  LOBRDBA,                                 -- LOBRDBA NUMBER
  LOBOBJID,                                -- LOBOBJID NUMBER
  LOBCURRTIME,                             -- LOBCURRTIME NUMBER
  LOBEXPMQL,                               -- LOBEXPMQL NUMBER
  LOBSQLMQL,                               -- LOBSQLMQL NUMBER
  LOBSPCANALTIME,                          -- LOBSPCANALTIME NUMBER
  LOBUNDORETTIME                           -- LOBUNDORETTIME NUMBER
from
  gv$lobstat
where
  inst_id = userenv('instance')

home |  up