Re: Amount of arc log differs in two identical db's ?

From: JAW <>
Date: Mon, 28 Dec 2009 11:39:50 -0800 (PST)
Message-ID: <>

On Dec 28, 3:44 am, eh <> wrote:
> Hi,
> There are two identical oracle 9.2 db's running identical software and
> basically amount of transactions is same - still there's a huge
> difference between archive log amount generated in these db's.
> Logs generated from other db is something like four times more ....
> Not going more deeper in this case - what could result this kind of
> behaviour ???
> Thanks,
> BR,
> timo

Assuming all things are almost equal could it be that you have FORCE LOGGING turned on for one and not the other which will make a big difference if your database has BLOBS.

select force_logging from v$database or something similar should tell you if FORCE LOGGING is on.

JAW Received on Mon Dec 28 2009 - 13:39:50 CST

Original text of this message