SlimDave
It is not that people try to impose their own opinions on how temp tablespace works or should work. I am still running on 8.1.7.0 and dba before me had nothing but DMT in the database. I recreated a new database and made every tablespace LMT except the system and come to find out the temp tablespace is always full and went up to 10 gig. If you dont add datafile users cannot perform any sort and you get bombarded with calls and you see your temp tablespace growing and growing because you keep adding datafiles.
So after investigation and after reading the documentation, I decided to simply use DMT for the temp tablespace and since then no problem. I can manually deallocate when need be and when there is no sorting going on since I cannot afford to shutdown the database every time I have full temp tablespace issue.
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.