There are several errors in this article. 1) AUM is not a requirement for Flashback Query (FBQ) 2) UNDO_RETENTION is not the max age for an FBQ, it is a guideline for how long to retain undo before reusing blocks (note...this is NOT a guarantee). Max age for an FBQ is coverned by the entries in the smon_scn_time table. If the instance is shutdown for a period of time and enough UNDO is available, you can flashback more than 5 days (which is documented).
If you are an IOUG member, download his paper/presentations from IOUG-A Live 2003. They are excellent. Daniel Fink "Bellow, Bambi" wrote: > Hi Folks! > > I got waylaid(?) when I got in this morning and these user dudes were > talking about using flashbacks, and I was like "Woah! Dudes! Let's just > chill on this for a couple of minutes". So, I went back to my desk and > checked out a cool article on it... > > http://www.oracle-base.com/Articles/9i/FlashbackQuery.asp > > And it looks like it's like, killer, yknow? So, I was thinking "well, we've > got sufficiently large undo segments for this, I don't see a problem with > it" but that didn't sound terribly cool, and anyway, before I go willy-nilly > saying this is the niftiest thing Oracle's done in years, I thought I would > run it by you guys and see if anybody out there is running with flashbacks > and whether there have been any problems with it. > > Yer far-out pal, > Bambi. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Bellow, Bambi > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
