Re: Temporary table use and the redo log
From: Eugene Pokopac <epokopac_at_gmail.com>
Date: Tue, 8 Sep 2009 07:06:41 -0700 (PDT)
Message-ID: <62184812-8043-492f-921e-aef8358ef904_at_j39g2000yqh.googlegroups.com>
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
Date: Tue, 8 Sep 2009 07:06:41 -0700 (PDT)
Message-ID: <62184812-8043-492f-921e-aef8358ef904_at_j39g2000yqh.googlegroups.com>
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