Why does my TEMP tablespace not clear after DB restart?
401820Nov 28 2005 — edited Nov 29 2005[Oracle 9.2]
Last week my TEMP tablespace filled after some badly written queries were executed.
I extended the tablespace from 4 to 6Gb.
Shortly afterwards it happened again, so up to 7Gb.
This morning it was again at 99.9% full, so it's now 9Gb.
The DB is restarted every night, should the DB not clear the used portion of TEMP to 0%?
Is the only way to return to 0% used, creating an alternative TEMP, making that default, removing the old one, creating the old one again, making the newest one the default, then deleting the alterntaive one?
Thanks