Re: spurious activities...

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 17 Jul 2003 23:44:15 -0700
Message-ID: <1a75df45.0307172244.35f8939e@posting.google.com>

"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. :-)

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?

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.

And no, ALTER SYSTEM KILL SESSION does not work on it.. (besides corrupting V$LICENSE and V$MAINTANANCE_AND_SUPPORT)

--
Billy

Received on Fri Jul 18 2003 - 01:44:15 CDT