GV$TEMPORARY_LOBS

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