Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |