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