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" <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).
Connor McDonald
web:
http://www.oracledba.co.uk
web:
http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com
"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: hamcdc_at_yahoo.co.uk
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).
Received on Fri Nov 07 2003 - 02:34:36 CST
