why undo_management=auto

From: aman.oracle.dba <aman.oracle.dba_at_gmail.com>
Date: 21 Dec 2006 03:34:59 -0800
Message-ID: <1166700899.640680.197680@79g2000cws.googlegroups.com>

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. Received on Thu Dec 21 2006 - 05:34:59 CST