DBA Data[Home] [Help]

VIEW: SYS.GV_$TEMPORARY_LOBS

Source

View Text - Preformatted

select "INST_ID","SID","CACHE_LOBS","NOCACHE_LOBS","ABSTRACT_LOBS","CON_ID" from gv$temporary_lobs
View Text - HTML Formatted

SELECT "INST_ID"
, "SID"
, "CACHE_LOBS"
, "NOCACHE_LOBS"
, "ABSTRACT_LOBS"
, "CON_ID"
FROM GV$TEMPORARY_LOBS