Re: why undo_management=auto

aman.oracle.dba wrote:
> Hello ALL,
>
> according to
> http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96521/undo.htm#9114
> the use of rollback segments for managing undo space will be deprecated
> in a future release.
> WHY....................
> what are the main advantages to keep separate undo_tablespace in
> database, when I can make one separate tablespace for rollback segments
> also.

Not that far into the future ... as of 10g they are gone.

Why?

Partially to put an end to ORA-01555, partially because DBAs have proven themselves incapable of managing rollback segments, and partially because the new algorithm improves many aspects of database existance and makes possible some aspects of flashback technology.

It would seem that Oracle has taken the same attitude toward rollback as they have taken toward temp ... we can do it better than you can. <g>

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org