Re: why undotbs01.dbf too big
Date: Thu, 21 Aug 2008 08:27:09 -0700 (PDT)
In addition to what others had to say, it's possible you have a guaranteed retention. Check "retention" in dba_tablespaces for the undo tablespace. A high undo_retention combined with guarantee option and with autoextend on, will lead to high undo datafile size. Whether you really need a guarantee option is up to you to decide.
-Madhu Sreeram Received on Thu Aug 21 2008 - 10:27:09 CDT