Re: Temporary table use and the redo log

From: Eugene Pokopac <>
Date: Tue, 8 Sep 2009 07:06:41 -0700 (PDT)
Message-ID: <>

Because the contents are temporary, they don't generate redo. They still generate undo, that's true. The undo segment updates cause 'some'
redo to be produced, but nevertheless: the amount of redo an update on a
temporary table causes should be much less than the amount of redo an identical 'proper' table would create. That means less log switches, less
checkpoints, less archives etc. Again, much lower overhead. Received on Tue Sep 08 2009 - 09:06:41 CDT

Original text of this message