I'm curious as to why you'd set autoextend on and not set a maxsize? You'll still need to monitor how much disk space is being allocated but you'll have a stopping point to keep the UNDO from taking all of the available space if the odd transaction hits that consumes unusually large amounts of UNDO. David Fitzjarrell ________________________________ From: patrick obrien <po04541@xxxxxxxxx> To: Oracle L <oracle-l@xxxxxxxxxxxxx> Sent: Mon, April 5, 2010 11:08:23 AM Subject: Okay to set undo to auto extend Oracle Admins, My Oracle 10.2 Undo tablespace Auto Extend feature is not turned on. That seems old school me. Any body know of a good reason, other than to watch available disk space, to no utilize auto extend for my undo table space? Thank you, POB.