Re: Why sometime redo log switch very fast?

From: music4 <music4_at_163.net>
Date: Sun, 6 Feb 2005 16:47:40 +0800
Message-ID: <cu4ljr$rvn@netnews.proxy.lucent.com>

> A redolog switch every minute is really undesirable, let alone every
> 20 seconds.
> If you have a redolog switch every 20 seconds it simply measn your
> application is generating three times as much redolog volume.
> You can easily find out what is going on using logminer.
>
> Oracle doesn't have any mechanism to increase the number of redolog
> switches.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

Sybrand,

Thanks for your answer. But the problem is from our applicaton's log, we am sure our application did generate too much redolog. So I want to check what generated too much redo?

And what's "logminer"? I cannot find it under $ORACLE_HOME/bin.

Evan Received on Sun Feb 06 2005 - 02:47:40 CST