Re: Strange undo behavior

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Tue, 17 Oct 2006 17:48:35 GMT
Message-ID: <TH8Zg.10025$gx6.9483@trnddc05>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hardball wrote:

>> How do you explain the used space in the undo tablespace going from < 10
>>> meg to almost 10 gig in a space of two hours where v$undostat shows that
>> < 50m of undo blocks have been written?

>
> Because you left the datafile(s) in the undo tablespace of interest set
> to autoextend?

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. -----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (MingW32)

iEYEARECAAYFAkU1F3MACgkQzIf+rZpn0oRw7ACePobVhA0TbabuqI5OYy5YJvVr dNsAoIQt2cc2kyaxiV8IajFEouFJX6Zm
=En0n
-----END PGP SIGNATURE----- Received on Tue Oct 17 2006 - 12:48:35 CDT