V$TEMPORARY_LOBS

Data Dictionary View

Columns
   ___________________________
 
   SID
   CACHE_LOBS
   NOCACHE_LOBS