View Single Post

   
  #1 (permalink)  
Old 02-25-2008, 07:39 AM
Michael42
 
Posts: n/a
Default Flashback and UNDO_RETENTION

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

Reply With Quote