GV$TEMPORARY_LOBS definition in Oracle Database 11.2
GV$TEMPORARY_LOBS

select
  kdlt.inst_id,                            -- INST_ID NUMBER
  kdlt.kdltsno,                            -- SID NUMBER
  sum(kdlt.kdltctmp),                      -- CACHE_LOBS NUMBER
  sum(kdlt.kdltnctmp),                     -- NOCACHE_LOBS NUMBER
  abs.count                                -- ABSTRACT_LOBS NUMBER
from
  X$KDLT kdlt,
  X$ABSTRACT_LOB abs
group by
  kdlt.inst_id,
  kdlt.kdltsno,
  abs.count
order by
  kdltsno

home |  up