TEMP tablespace growing without control
Hi all,
i have migrated an oracle istance from 8.1.6 to 9.2. Everything seems to work normally but i have a problem with the TEMP tablespace. some application are working on data with sort operations and the TEMP tablespace keep on growing without releasing any space. the thing is that the automatically extend of my TEMP tablespace make my file system almost full after some time.
tha same application, working with the older 8.1.6, didn't show this strange behaviour (the old TEMP tablespace was 1 GB and it was more than enough). right now it grows over 2 GB...
the only solution i have is to create a new TEMP tablespace and remove the growing one every two/three days...
is this a problem related to the application or to my database?
how can i solve it?
thank you very much
matteo