Michael42 wrote:
> Hello,
>
> In an Oracle 10g R2 database on Solaris 10 I have a table that is
> 150gb. Could you please help me determine how big my UNDO_RETENTION
> should be set to:
>
> 1. To be able to use Flashback Query on this table for up to 24 hours.
> 2. To be able to use Flashback Dropped table on this table for up to 24
> hours.
>
> Thanks very much,
>
> Michael42
desc gv_$undostat
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Oct 07 2006 - 12:27:59 CDT
