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 -----------------------------------------------------------------