Re: Strange undo behavior

> There are two datafiles in the tablespace. Both have autoextend on,
> maxsize of 5g, and have been at the max of 5g for probably over a year.
>
> How does that explain a growth in undo extents from 10m to 9.5g when
> only 38m have been written according to v$undostats.

Is it possible that Oracle is created more undo segments in the tablespace? Under certain workload conditions, Oracle will create new undo segments in the UNDO tablespace. Oracle does not drop those undo segments assuming that they will be used in the future.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown