Hi experts,
I've got a Oracle 10g database hosted on a Sun solaris Server.
Sometimes when users issue huge queries, the TEMP tablespace gets filled and the DB issues random errors whenever a complicated query is issued.
In such situations, when the actual DBA is not there, I just shutdown then restart the DB (it's a small datawarehouse DB) to flush the TEMP tablespace a get a clean one upon restart.
Unfortunately I'm currently facing this problem, and this time restarting the DB does not help.
How could I get a fresh TEMP tablespace? Of course I could extend it (add another datafile), but it is already rather large (about 26 Go). Maybe I should extend it first, and then restart ? (It currently has close to 0% free space)
Any suggestion welcome
Hilaire
Start Free Trial
