Space problem in TEMPORARY tablespace
Does anyone can help me to understand how temporal space is used?
The size of the TEMPORARY tablespace named TEMP is 40 Gb and it has only 110 Mbs free
select tablespace_name,
round(sum(bytes_used + bytes_free) / 1048576, 2) SizeMgs,
round(sum(bytes_free) / 1048576,2) FreeMgs,
round(sum(bytes_used) / 1048576,2) UsedMgs,
round((sum(bytes_free) / sum(bytes_used + bytes_free)) * 100,2) Pct_Free,
100 - round((sum(bytes_free) / sum(bytes_used + bytes_free)) * 100,2) Pct_used
from sys.v_$TEMP_SPACE_HEADER
group by tablespace_name
TABLESPACE_NAME SIZEMGS FREEMGS USEDMGS PCT_FREE PCT_USED
------------------------------ ---------- ---------- ---------- ---------
TEMP 40480 110 40370 0.27 99.73
I tried to find the sessions using this temporal space, but I only found 6 Gb