Oracle: V$TEMPORARY

For sessions that are using temporary LOBs, v$temporary_lobs shows where the LOBs's data resides.

Columns

`sid`	The session identifier.
`cache_lobs`	Number of LOBs in the temporary tablespace using cache.
`nocache_lobs`	Number of LOBs in the temporary tablespace not using cache.
`abstract_lobs`	Number of LOBs in the PGA.
`con_id`	The pluggable database container id.