Re: optimal size for rollback

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: 13 Sep 2002 14:37:45 -0700
Message-ID: <altlr90i3i@drn.newsguy.com>

In article <3D8225DA.4687_at_yahoo.com>, Connor says...
>

snip
>
>And what's more (imho), automatic undo is basically an OPTIMAL clause
>just under the covers...Its like "Oops, I'm an extent thats 3 seconds
>over the retention limit...bang, I'm outta here"
>
>Cheers
>Connor
>--
>==============================
>Connor McDonald
>
>http://www.oracledba.co.uk
>
>"Some days you're the pigeon, some days you're the statue..."

Bloody cynical Aussie! :)

It is of course much more than that. The things I really like about it are the not worrying about numbers of segments, and the politically correct dynamic extents transfer (also known as extent stealing to us cynical Aussies!)

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Fri Sep 13 2002 - 16:37:45 CDT