Re: why undo_management=auto

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 21 Dec 2006 04:39:14 -0800
Message-ID: <1166704754.123678.152780@48g2000cwx.googlegroups.com>

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.

Google Search:
http://www.google.com/search?hl=en&q=snapshot+too+old

Documentation:
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/undo.htm

In short, undo offers less management hassle to deal with, when making certain that the rollback segments (all of them) are sufficiently sized to handle all possible combinations of transactions in order to reduce the chances of receiving Snapshot Too Old errors.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Thu Dec 21 2006 - 06:39:14 CST