RE: flashback query vs. log miner
- From: Kirtikumar Deshpande <kedeshpande@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 26 Jul 2004 09:12:39 -0700 (PDT)
Mark,
You have a strong memory :-)
In one my test databases FBQ does work for upto 10 days of instance uptime :)
Yes, hacking of SYS owned object is required to extend the 5-day limit.
And unless it is a throw-away database, I would advise against it !!
Cheers!
- Kirti
--- "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx> wrote:
> I'm pretty sure that 5 days is a hard limit, unless you're into hacking
> the database.....;-)
>
> As I recall a certain dinner in Dallas, Kirti described how he
> successfully did so, extending the 5 day limit to, um, 10 days,
> perhaps....? ;-)
>
> But, I don't think that would be a recommended approach for a production
> database....;-)
>
> Mark J. Bobak
> Oracle DBA
> ProQuest Company
> Ann Arbor, MI
> "Post Hoc Ergo Propter Hoc"
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
> Paula_Stankus@xxxxxxxxxxxxxxx
> Sent: Monday, July 26, 2004 11:42 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: RE: flashback query vs. log miner
>
>
> Thanks Kirti,
>
> That was a very concise description and along the lines of what I was =
> =3D
> telling a junior dba I am training. =3D20
>
> However, is it a hard limit for FBQ - 5 days - or is it solely based on
> =3D
> undo tablespace size and undo tablespace retention parameter? =3D20
>
> Also, is there any downside with allocating a great deal of space to the
> =3D
> undo tablespace in a database other than static allocation?
>
>
>
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
----------------------------------------------------------------
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
-----------------------------------------------------------------
Other related posts:
