Re: Amount of arc log differs in two identical db's ?
Date: Mon, 28 Dec 2009 00:59:00 -0800 (PST)
Please post top sections of Statspack report for both databases: redo log generation
per second, number of transactions per second, average transaction size, etc.
I could think of two reasons:
- One database has tablespaces in backup mode: ALTER TABLESPACE <name>
BEGIN BACKUP have been executed. In this case Oracle writes entire block to redo logs.
- One database has FORCE LOGGING enabled. Let's say you are doing
CREATE TABLE AS SELECT NOLOGGING, in the database with FORCE LOGGING the NOLOGGING option will be ignored and it will lead to increased generation of redo Received on Mon Dec 28 2009 - 02:59:00 CST