Additional redo for supplemental logging at table level
From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Date: Thu, 22 Dec 2011 12:57:49 -0500
Message-ID: <304F58144267C5439E733532ABC9A3A113A9AEAA_at_USA0300MS02.na.xerox.net>
Hi,
I would like to know if anyone has done any testing on how much additional redo is generated if supplemental log groups are created on tables. I know that it will depend on the number of columns in a log group, column size, data type, etc., but I just want to get an idea about generally how much additional information (in terms of %age) is generated for DML statements.
Date: Thu, 22 Dec 2011 12:57:49 -0500
Message-ID: <304F58144267C5439E733532ABC9A3A113A9AEAA_at_USA0300MS02.na.xerox.net>
Hi,
I would like to know if anyone has done any testing on how much additional redo is generated if supplemental log groups are created on tables. I know that it will depend on the number of columns in a log group, column size, data type, etc., but I just want to get an idea about generally how much additional information (in terms of %age) is generated for DML statements.
Any feedback will be appreciated.
Thank you
Amir
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 22 2011 - 11:57:49 CST