Re: diff bewteen 8i and 9i?

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<991313383.19703.0.nnrp-12.9e984b29_at_news.demon.co.uk>...
> --
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Practical Oracle 8i: Building Efficient Databases
> Publishers: Addison-Wesley
>
> Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
>
>
>
> Nuno Souto wrote in message <3b161fc0.860355_at_news-server>...
> >On Thu, 31 May 2001 19:12:28 +1000, "Howard J. Rogers"
> ><howardjr_at_www.com> wrote:
> >
> >
> >>Incidentally, I forgot to mention: ORA-1555s are a thing of the past,
 since
> >>you can now protect rollback required for read-consisitent image
 preparation
> >>for any given length of time (the default appears to be 30 seconds). Must
> >>be worth an upgrade for that fact alone, I'd say.
> >
> >
> >Hehehe! Not so fast, bro Rogers! It's still possible, we just can
> >delay it for quite a while. Or so my reading of David's prezzie lead
> >me to believe.
> >
> >Not sure exactly how that's gonna work. How the heck are we supposed
> >to know what's a sufficient delay? Suck it and see?
> >
>
>
> Of course, it does require you to specify a tablespace
> made of files that can autoextend - then it just lets
> the rollback segments grow as big as necessary.
> It's a nice easy option for slowing the database
> down if you want to be lazy and avoid thinking.

Just curious why you think this feature won't help in general. Maybe you can email me off-line. But creating a tablespace, setting the retention time and you're done seems a lot better than worrying about TX table concurrency, snapshot too old etc etc. There is even a view that keeps track of how much undo space has been used every 5 mins (or 20 mins) and you can watch that for a day and figure out your retention time if you're not sure how to set it Received on Sat Jul 28 2001 - 01:37:08 CEST