V$TEMPORARY_LOBS definition in Oracle Database 11.2
V$TEMPORARY_LOBS

select
  SID,                                     -- SID NUMBER
  CACHE_LOBS,                              -- CACHE_LOBS NUMBER
  NOCACHE_LOBS,                            -- NOCACHE_LOBS NUMBER
  ABSTRACT_LOBS                            -- ABSTRACT_LOBS NUMBER
from
  GV$TEMPORARY_LOBS
where
  inst_id = USERENV('Instance')

home |  up