My Oracle temp tablespace is 100% utilized.
I am trying to Flush it out by re-starting the database but still after the re-start it shows 100% utilized.
Can any one tell me what might be the reason.
As far as i know Oracle(i m using 10g) frees temp tablespace automatically .
Now i have an option to re-create the TEMp tbs AND fix this issue but i would like to know why issue is not getting
fixed after restart