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_at_il.proquest.com> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
> Paula_Stankus_at_doh.state.fl.us
> Sent: Monday, July 26, 2004 11:42 AM
> To: oracle-l_at_freelists.org
> 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_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
-----------------------------------------------------------------
Received on Mon Jul 26 2004 - 11:12:58 CDT
