Delayed block cleanout and changing automatic undo tablespace 2004-07-20 - By Daniel Fink
I 'm going to take the easy question first...
If you are using AUM, you cannot offline undo segments without switch=
ing undo tablespaces. You also can 't create new ones or drop=20
old ones. If something happens that creates a bunch of undo segments =
(another issue), you are stuck with them until you are able to=20
drop the tablespace.
If you bounce the database, you will see that a limited number of seg=
ments are online. As transactions are processed, segments are=20
onlined or created as the system sees fit. You no longer have any con=
trol over your undo.
I have a rather detailed paper and presentation about undo at www.opt=
imaldba.com/library.html.
Regards,
Daniel Fink
Tim Onions wrote:
> Many thanks for the fast response. Sorry to ask a dumb question but=
with
> AUTO UNDO in 9i how can one "...offline the undo segments.. ". There=
are no
> active transactions on the segments in the old large undo tablespac=
e show
> via V$transaction.
>=20
> Thanks
>=20
> T=AC
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> To unsubscribe send email to: oracle-l-request@(protected)
> put 'unsubscribe ' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
