Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9.2.0.1.0 Undo Management?
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 ForbrichReceived on Sat Jun 18 2005 - 17:08:39 CDT
![]() |
![]() |