V$TEMPORARY_LOBS

V$TEMPORARY_LOBS displays temporary LOBs.

Column Datatype Description
SID NUMBER Session ID
CACHE_LOBS NUMBER Number of cache temp LOBs
NOCACHE_LOBS NUMBER Number of nocache temp LOBs
ABSTRACT_LOBS NUMBER Number of abstract LOBs