Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> TEMP Tablespace not clearing
When we run a process in the database, the Temp tablespace fills
up. Looking at OEM Storage Manager, shouldn't the Amount Used
decrease back down to zero after the process has been finished
and committed when there isn't anything else running on the database?
Ours doesn't seem to clear out. Does temp clear out when the
table being sorted is no longer being sorted or is there some
other DB process that comes along periodically and cleans it
out?
![]() |
![]() |