Re: Amount of arc log differs in two identical db's ?
Date: Mon, 28 Dec 2009 11:39:50 -0800 (PST)
On Dec 28, 3:44 am, eh <timo.talja.em..._at_gmail.com> wrote:
> 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 ???
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