Re: Okay to set undo to auto extend
- From: David Fitzjarrell <oratune@xxxxxxxxx>
- To: po04541@xxxxxxxxx, Oracle L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 5 Apr 2010 08:29:25 -0700 (PDT)
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.
Other related posts: