Re: spurious activities...

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Mon, 21 Jul 2003 14:18:34 +0200
Message-ID: <bfglmr$j79$1@news.fujitsu-siemens.com>

Billy Verreynne wrote:
> "Volker Hetzer" <volker.hetzer_at_ieee.org> wrote
>
>

>>Since a few months I'm in charge of an oracle db (9.2.0.3.0, linux).
>>A week ago I set the archive_lag target so I could see what happens
>>when there's no activity.
>>The result was that the db created 900K of redo info per hour, even if
>>nothing happens. The archived redologs are roughly similar in size
>>(890K-950K, once 500K). The redologs themselves are configured to
>>be 50M in size.
>>Is this redo activity normal?

>
>
> Define normal. :-)

Is it supposed to happen?

> Define no activity and "nothing happening".. does that mean no
> DBMS_JOBs or any other form of background processing? Does that mean
> not a single transaction or DLL during that time?
Everybody's home sleeping. One or two sessions logged on with no activity.
select * from dba_jobs;

        no rows selected

> If the answer is yes.. well then you have discovered a secret Oracle
> process that does an iterative INSERT INTO larry_wallet VALUES
> (lots_of_money) in the background.

:-)

Lots of Greetings!
Volker Received on Mon Jul 21 2003 - 07:18:34 CDT