RE: Rapid Log Switching (one more thought)

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Thu, 21 Feb 2008 05:55:32 -0500
Message-ID: <014401c87478$48f4f610$1100a8c0@rsiz.com>


If it IS something like private threads consuming between 14 and 18 of the 20M so the switching is driven at between 2 and 6, then simply adding a set of much larger online redo logs would be a good diagnostic. If it is any sort of hidden space consumption it should become apparent.  

Is the time of switching rigidly periodic while the size varies? If the time of switching is consistent I'd be inclined to focus the search on something generating a manual switch or an inadvertant value in the log switching time parameter.  


From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mark W. Farnham
Sent: Wednesday, February 20, 2008 7:30 PM To: John.Weatherman_at_asurion.com; 'Roman Podshivalov' Cc: oracle-l_at_freelists.org
Subject: RE: Rapid Log Switching  

Is your alert log any help? Is anyone issuing "alter system switch logfile" ? Possibly someone botched a cron issuing that before backups? This is all wild guessing, but if you haven't changed anything in Oracle on purpose, we're left with changes outside of Oracle, right?  

Good luck. Sure seems mysterious to me.  


From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Weatherman, John
Sent: Wednesday, February 20, 2008 5:33 PM To: Roman Podshivalov
Cc: oracle-l_at_freelists.org
Subject: RE: Rapid Log Switching  

archive_lag_target is 0.

Nothing else is strange or has changed for months..I've been trying to make changes and can't get approval!  

<snip>  

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 21 2008 - 04:55:32 CST

Original text of this message