Re: Flashback and UNDO_RETENTION

"Michael42" <melliott42_at_yahoo.com> wrote in message news:1160391861.301788.146110_at_c28g2000cwb.googlegroups.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 Received on Mon Oct 09 2006 - 15:51:56 CDT