Re: why undotbs01.dbf too big
From: <madhusreeram_at_gmail.com>
Date: Thu, 21 Aug 2008 08:27:09 -0700 (PDT)
Message-ID: <b86bedd1-b5e2-42e5-9f3a-57956bf9986d@34g2000hsh.googlegroups.com>
Date: Thu, 21 Aug 2008 08:27:09 -0700 (PDT)
Message-ID: <b86bedd1-b5e2-42e5-9f3a-57956bf9986d@34g2000hsh.googlegroups.com>
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