Hi guys.

Our database has 50GB of undo tablespace. I decided to create a second
undo tablespace and switch to the new one. Since doing that yesterday,
the size of the old undo is 49GB (was thinking that the values will drop
to zero) and the new tablespace keeps increasing in size! Its size now
is about 20GB. I do have the following question.

a) If I restart the database, it the value of the old undo going to fall
to zero?
b) undo_retention=86400. Setting this value to a lesser value say
800seconds, it is going to act the performance of the database? Is it
going to release the space on the old undo?
Thanks and any help is appreciated.
David



NOTE: This e-mail message is subject to the MTN Cameroon disclaimer, see http://www.mtncameroon.net/disclaimer.html

Oracle LazyDBA home page