GV$TEMPORARY_LOBS

select
inst_id,                 -- INST_ID NUMBER
kdltsno,                 -- SID NUMBER
sum (kdltctmp),          -- CACHE_LOBS NUMBER
sum (kdltnctmp)          -- NOCACHE_LOBS NUMBER
from
X$KDLT 
group by inst_id,
kdltsno order by kdltsno
home |  up  |  mailbox