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  |  mailbox