Dear List,
I am trying to find out if setting undo_retention to non-zero value will generate more redo log or not. I dummy up some update and insert transactions and ran it in a 9.2 db with undo_retention=0 and undo_retention=900 (the default), I monitored the redo size by querying 'redo size' stat in v$sysstat. And I found out that the amount of redo generated under both undo_retention is about the same. I would have thought that with undo_retention=non-zero value will generate more redo because of the undo entries and these undo will be in the redo stream as well. However, from the test result it doesn't seem to be the case. Is it my understanding of undo is wrong or the test I did is not right?
Josh
Find local movie times and trailers on Yahoo! Movies.
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 May 13 2004 - 10:59:13 CDT
