Re: Wow, Man, Flashbacks!

Hi!

It was only the SCN <-> time mapping informatin which is aged out after 5 days, but you still can use SCN-based flashback back to your oldest undo record.

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, November 07, 2003 10:04 PM

> Others have mentioned it, but I just wanted to chime in to warn you to
warn
> your developers, that they will only have five days to use their frozen
> moment in time. This is the limitation imposed by the scn table mentioned
> in Dan's post. The reason I decided to chime in is that AFAIK, no
official
> Oracle documentation refers to this limitation. This is just one of those
> odd things I wouldn't know, if it weren't for my association to this list.
>
> -----Original Message-----
> Bellow, Bambi
> Sent: Friday, November 07, 2003 8:19 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Melanie --
>
> What's happening is that, in a write-intensive environment, the developers
> want to "freeze a moment in time" which can be used across developers and
> applications for testing to ensure consistent results. The functionality
> may be expanded, in time, depending on how it works. But from what I'm
> seeing, this seems to be the right tool for the job.
>
> Thanks, everyone, for your feedback. In my book, this goes down as
Oracle's
> coolest feature since DECODE.
>
> Bambi.
>
> -----Original Message-----
> Sent: Thursday, November 06, 2003 11:45 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Bambi,
>
> I hate to sound repetitive, but, it depends. :-)
>
> It depends on how far you want to flash back to.
>
> One of my clients was being audited last year by their
> parent company.
>
> I put in a retention period of about a week at a time.
>
> Without divulging much from my confidentiality
> agreement with them, we were really trying to figure
> out what certain users were doing within the company,
> and we provided proof of such. Using the flashback
> query feature made this incredibly easy to do!
>
> Of course, you have to be careful with your UNDO
> segments, as you know.
>
> I didn't try going backwards for more than a week.
> That was all we needed at the time.
>
> I also turned this feature off once we were done.
>
> Other than UNDO segment growth, which I planned for in
> advance, I didn't have any problems with it. And it
> made the task at hand incredibly easy.
>
> But, I wouldn't recommend putting it in place unless
> you really need it.
>
> My $0.02,
> Melanie
>
> --- "Bellow, Bambi" <bbellow_at_chi.navtech.com> 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).
>
>
> __________________________________
> Do you Yahoo!?
> Protect your identity with Yahoo! Mail AddressGuard
> http://antispam.yahoo.com/whatsnewfree
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Melanie Caffrey
> INET: melanie_caffrey_at_yahoo.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: 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: Steve McClure
> INET: smcclure_at_usscript.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: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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).