> Jared, > I don't think that it is the amount of data changes even if they are > caused by the Oracle meteorollgists, It depend on the undo_retention > parameter > and the size of the disk space available for the undo_tablespace. > If the undo_retention is set to 1 hour then the undo data is saved for > 1 hour. IIRC, there are no guarantees that Oracle will actually save the data for 1 hour. It will make a best effort, but a 'storm' of activity could subvert that. Jared ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------