Re: Flashback and UNDO_RETENTION

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
>

If you need to be able to perform Flashback Query for any time in the past 24 hours, then UNDO_RETENTION should be set to at least 86,400 (24 hours * 60 minutes/hr * 60 seconds/min).

Flashback Drop does not use the UNDO tablespace. Rather, it used the Recycle Bin.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown