Re: Oracle 9.2.0.1.0 Undo Management?

From: HansF <News.Hans_at_telus.net>
Date: Sat, 18 Jun 2005 22:08:39 GMT
Message-Id: <pan.2005.06.18.22.11.44.115823@telus.net>

On Sun, 19 Jun 2005 03:06:56 +0800, Jackie Chang interested us by writing:

> 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!

When you check it again (31st time), make sure you try it later than (the first transaction time + the undo retention duration). Then tell us what has happened.

-- 
Hans Forbrich

Received on Sat Jun 18 2005 - 17:08:39 CDT