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')