Re: why undotbs01.dbf too big

From: <>
Date: Thu, 21 Aug 2008 08:27:09 -0700 (PDT)
Message-ID: <>

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

Original text of this message