Paula,
For FBQ, in Oracle 9i, there is a hard limit of 5 days of instance uptime. Period! No
amount of undo space and undo retention time can cross this limit. And, there are ways to
size the undo tablespace to suit your requirements.
I presented a paper on 9i AUM and FBQ in the recent IOUG conf. You may refer to my
paper. It discusses all these issues, and shows why there is a 5-day instance uptime
limit for FBQ in Oracle 9i.
Regards,
- Kirti
- Paula_Stankus_at_doh.state.fl.us wrote:
> Thanks Kirti,
>
> That was a very concise description and along the lines of what I was =
> telling a junior dba I am training. =20
>
> However, is it a hard limit for FBQ - 5 days - or is it solely based on =
> undo tablespace size and undo tablespace retention parameter? =20
>
> Also, is there any downside with allocating a great deal of space to the =
> undo tablespace in a database other than static allocation?
>
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Kirtikumar Deshpande
> Sent: Saturday, July 24, 2004 10:50 AM
> To: oracle-l_at_freelists.org
> Subject: RE: flashback query vs. log miner
>
>
> Paula,
> One must use LogMiner if one needs to access data that is more than 5 =
> days old (instance
> uptime wise). FBQ does not help you. Of course, this changes with Oracle =
> 10g ( and what
> doesn't? ;).=20
>
> Also, with 9i rel 2 SQL enhancement (the AS OF clause) it is very easy =
> to use FBQ to
> access past data (if it is still available in the undo segments). =
> Accessing the same
> information via LogMiner is a bit more involved process. With proper =
> privileges, you can
> let your developers use FBQ, but I doubt if DBAs will allow Developers =
> to play with
> LogMiner. =20
>
> So, I would not use one versus the other all the time, but may be =
> required to use both,
> depending on the requirement.=20
>
> Regards,
> - Kirti
> =20
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
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:03:16 CDT
