Re: Delayed block cleanout and changing automatic undo tablespace
- From: Daniel Fink <Daniel.Fink@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 20 Jul 2004 07:11:24 -0600
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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
