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.

The main advantage of UNDO segments is they make ongoing rollback maintenance a thing of the past. They are there to make your work easier (or more redundant), so you need to ask less ' I didn't read the docs' questions.

-- 
Sybrand Bakker
Senior Oracle DBA