Yes, the activity is important and natuarally that's why I'm concerened about the size of the undo tablespace and performance degradation as a result. The latter is a concern only as of now; not founded on any specific benchmark or performance figure. The flashback is expected to be on a highly volatile OLTP database and the size will be considerable. ----- Original Message ----- From: "Connor McDonald" <hamcdc@xxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Thursday, February 12, 2004 1:14 AM Subject: Re: Undo Retention of 5 days; anyone? > I'd say the issue is not "5 days", but how much is "5 days worth of transactions". If there is > lots (of txns) thats sounds like a very very big undo tablespace...It might almost be easier just > to have 5 copies of the database, marked "today", "today-minus-one" etc - which would be far > quicker to query :-) > > Cheers > Connor > > --- Arup Nanda <orarup@xxxxxxxxxxx> wrote: > List, > > I have a very unusual request from users to have UNDO_RETENTION set to 5 days. Normally I set to > > about 5 hours, not days. Don't ask why. They have inherited a bad design that requires flashing > > back to 5 days ago and, no, they can't redesign it. > > > > I'm curious if anyone has actually done it, i.e setting it to a very high value. Any input will > > be highly appreciated. > > > > Thanks a lot in advance. > > > > Arup > > ---------------------------------------------------------------- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > ---------------------------------------------------------------- > > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > > put 'unsubscribe' in the subject line. > > -- > > Archives are at //www.freelists.org/archives/oracle-l/ > > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > > ----------------------------------------------------------------- > > ===== > Connor McDonald > Co-author: "Mastering Oracle PL/SQL - Practical Solutions" - available now > web: http://www.oracledba.co.uk > web: http://www.oaktable.net > email: connor_mcdonald@xxxxxxxxx > > "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" > > > > > > ___________________________________________________________ > BT Yahoo! Broadband - Free modem offer, sign up online today and save £80 http://btyahoo.yahoo.co.uk > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------