Undo normally occupies a sizeable portion of your buffer cache - a good thing too, because they're hammered for consistent read and the like.
Of course, if your undo segments are massive, then the percentage of any given undo segment being the cache drops...Massive undo segments *might* be setting you up for a big physical IO hit on your undo datafiles. (so its the familiar mantra of benchmark, benchmark, etc etc) hth connor --- "Bellow, Bambi" <[EMAIL PROTECTED]> 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). ===== Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" ________________________________________________________________________ Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
