RE: What can cause a rapid frequency of log switches?

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Fri, 4 Jun 2004 16:11:32 -0700
Message-ID: <B5C5F99D765BB744B54FFDF35F60262109F878BB@irvmbxw02>

Thanks to everyone that answered. The log switches were caused by activity in the database. It turns out that he was running Spotlight on the wrong instance and thought for sure there was nothing going on in the database with the high amount of log switches.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mark W. Farnham Sent: vendredi, 4. juin 2004 15:56
To: oracle-l_at_freelists.org
Subject: RE: What can cause a rapid frequency of log switches?

Are the archived logs about 400MB, or are they very short or zero length?

If about 400MB, then something is causing a lot of redo generation. If the number of archives is getting to be bothersome, make them bigger.

If zero or about zero, then it *might* be failing to write to the next group so it switches. If it can't find something valid to switch to, this should be pretty obvious, since commits will hang until you can write them to redo. I can't remember whether it marks a group invalid if it fails to write to it or whether it could possibly run in a circle until you give it something usable to write to. Failures would almost certainly be found in the alert log.

mwf

	-----Original Message-----
	From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jacques Kilchoer
	Sent: Friday, June 04, 2004 6:24 PM
	To: oracle-l_at_freelists.org
	Subject: RE: What can cause a rapid frequency of log switches?
	
	
	Not my database though and I'm not at the site. I'm telling my

friend "it has to be database activity, there is no other reason."

Jared.Still_at_radisys.com

oracle-l-bounce_at_freelists.org wrote on 06/04/2004 01:38:23 PM:

> Oracle 9.2.0.4 / AIX 5.1
>
> I'm looking at an issue with redo log switches.
> As far as I know, a log switch will only happen
> A) if the log is full
> B) if someone enters an "alter system switch logfile"
> C) if archive_log_target is set
>
> I've been asked why there would be a log switch in less than a
minute

> (the redo logs are all 400 MB in size). The only answer I
could think of

> is that there is a lot of activity in the database. Is there
some

> possibility I'm overlooking?
>

	Well, you could speculate, or you could use log miner and see 
	what's going on. 
	
	Jared 
	


----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jun 04 2004 - 18:08:32 CDT