Re: Amount of arc log differs in two identical db's ?
From: JAW <willjamu_at_gmail.com>
Date: Mon, 28 Dec 2009 11:39:50 -0800 (PST)
Message-ID: <10572aa6-32ae-4425-b994-aea3e76e5888_at_h10g2000vbm.googlegroups.com>
On Dec 28, 3:44 am, eh <timo.talja.em..._at_gmail.com> 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
Date: Mon, 28 Dec 2009 11:39:50 -0800 (PST)
Message-ID: <10572aa6-32ae-4425-b994-aea3e76e5888_at_h10g2000vbm.googlegroups.com>
On Dec 28, 3:44 am, eh <timo.talja.em..._at_gmail.com> 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