> 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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Aug 12 2004 - 13:10:36 CDT
