Originally posted by davey23uk
but if this in a a production system your useers do not want their long running queries stopping with an error.
If its not causing a problem with disk space or whatever, let it grow monitor it and fix things that cause problems
Have you lost your mind? If you've got a process sucking up more than 2gigs of temp on your PRODUCTION box and you didn't catch it while it was in dev then it's your own fault.
Now go sit in the corner you're in time out.
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg