"Michael42" <melliott42@yahoo.com> wrote in message
news:1160391861.301788.146110@c28g2000cwb.googlegr oups.com...
> Dan, Brian,
>
> Thanks very much for the responses. Very useful!
>
> In addition to setting the UNDO_RETENTION, how would one determine the
> size required for the UNDO tablespace (if this is even a factor in this
> case)?
>
> Thanks again,
>
> Michael42
>

By looking at the V$UNDOSTAT dynamic view.
Example : http://www.akadia.com/services/ora_optimize_undo.html.


Matthias