Joel.Patterson@xxxxxxxxxxx wrote,on my timestamp of 14/04/2009 3:25 AM:
There is still an argument to be made however for limiting undo and temp as these would be the most likely to run away, and if so, the fix isn't to add more files.
My approach is to use autoextend to the point where it encroaches on the file system size. IE: I set it to stop growing if the total size gets near the f/s size. This way we've been able to trap quite a few runaway processes before they did damage anything while allowing everyone to sleep at night. Works for me. -- Cheers Nuno Souto in sunny Sydney, Australia dbvision@xxxxxxxxxxxx -- //www.freelists.org/webpage/oracle-l