| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Undo Retention of 5 days; anyone?
It would be difficult if not impossible for the Oracle Kernel to allow you=
to
specify which objects have Undo_Retention and for what duration.
A transaction across multiple objects must have Undo retained for the
entirety of the transaction, irrespective of the number of tables and the
number of rows in each table.
Hemant
At 12:38 PM 14-02-04 +1000, you wrote:
>It might be a nice enhancement if we could decide which objects require
>"undo retention" perhaps via a setting at the object creation level=
(yes/no,
>1hr/5days, etc) rather than having to retain every change in the entire
>database. That said, it would require significant modifications in how undo
>segments work so I'm glad I can make such suggestions without having to
>actually implement them ;)
>
>Cheers
>
>Richard
>----- Original Message -----
>From: "Arup Nanda" <orarup_at_hotmail.com>
>To: <oracle-l_at_freelists.org>
>Sent: Friday, February 13, 2004 1:30 PM
>Subject: Re: Undo Retention of 5 days; anyone?
>
>
>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_at_yahoo.co.uk>
>To: <oracle-l_at_freelists.org>
>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_at_hotmail.com> 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_at_freelists.org
> > > put 'unsubscribe' in the subject line.
> > > --
> > > Archives are at http://www.freelists.org/archives/oracle-l/
> > > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > > -----------------------------------------------------------------
> >
> > =3D=3D=3D=3D=3D
> > 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_at_yahoo.com
> >
> > "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=
=A380
>http://btyahoo.yahoo.co.uk
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://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_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://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_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com {last updated 24-Jan-04}
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Sun Feb 15 2004 - 08:34:47 CST
 |
 |