Re: Oracle 9.2.0.1.0 Undo Management?

From: Jackie Chang <no_at_mail.com.tw>
Date: Sun, 19 Jun 2005 03:06:56 +0800
Message-ID: <d91rel$i21$1@news.seed.net.tw>

Oracle 9.2.0.1.0 undo tablespace extend managment use LOCAL. I think the tablespace set to autoextend.
I use Oracle Enterprise Manager Console check it! And check UNDOTBS01.DBF file size!

Undo_retention to large(10800 9iR2 default), So Oracle does not reuse undo tablespace.
Thinks a lot!

Jackie Chang!

> Jackie, you have provided insufficient information in your post.
>
> What specific version of Oracle? I will guess 9.2 something from the
> connect string
>
> What are the undo tablespace parameters? You imply that it is set to
> autoextend.
>
> What query are you using to look at size?
>
> What value is undo_retention set to?
>
> How many megabytes of data does the update generate?
>
> Without knowing any specifics I will guess that Oracle extended the
> undo tablespace to be able to retain the data for the time period
> specified by undo_retention.
>
> HTH -- Mark D Powell --
>
Received on Sat Jun 18 2005 - 14:06:56 CDT