Re: spurious activities...

From: JoeB <nomail_at_nomail.com>
Date: Fri, 18 Jul 2003 13:01:12 +0100
Message-ID: <dkRRa.164$Ai3.34@newsfep4-winn.server.ntli.net>

"Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message news:bf5ves$p6r$1_at_news.fujitsu-siemens.com...
> Hi!
> 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?
>
> Lots of Greetings!
> Volker
>

Why don't you use logminer to see what's going on when "nothing happens"?

JoeB Received on Fri Jul 18 2003 - 07:01:12 CDT