Re: Wow, Man, Flashbacks!

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: bbellow_at_chi.navtech.com
>
> 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: ListGuru_at_fatcity.com (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: Daniel.Fink_at_Sun.COM

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: ListGuru_at_fatcity.com (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).