RE: Rapid Log Switching
Date: Wed, 20 Feb 2008 15:26:55 -0600
Didn't get this to the list...sorry...
From: Weatherman, John
Sent: Wednesday, February 20, 2008 2:43 PM To: 'Bradd Piontek'
Subject: RE: Rapid Log Switching
Our TARGETS are:
archive_lag_target integer 0 db_flashback_retention_target integer 360 fast_start_io_target integer 0 fast_start_mttr_target integer 0 pga_aggregate_target big integer 384M sga_target big integer 2G
From: Bradd Piontek [mailto:piontekdd_at_gmail.com]
Sent: Wednesday, February 20, 2008 2:38 PM
To: Weatherman, John
Subject: Re: Rapid Log Switching
What is fast_start_mttr_target set to?
Are you using Auto. memory management?
On Wed, Feb 20, 2008 at 1:58 PM, Weatherman, John
<John.Weatherman_at_asurion.com <mailto:John.Weatherman_at_asurion.com> > wrote:
I'm on RH 2.6.9-42.ELsmp x86_64 Linux, running 10.2.0.3 <http://10.2.0.3> . I've been having a lot of log issues for the last week. Thanks to some help here, I seem to have the worst of it under control now.
However, last night I began seeing log switches every 6 minutes. The logs are 20M in size, but are switching between 2-6M. We do have log_checkpoint_timeout set, but it is 1800 seconds (30 minutes), not 6 minutes.
Does anyone have any ideas what other than the timeout or the log filling up would cause a log switch? It's not manual and it's not backups, it's been too consistent and too long for either of those to make any sense. I'm not aware of anything else that should be triggering log switches and haven't been able to find anything suspicious with Google or Metalink.
John P Weatherman john.weatherman_at_asurion.com
Sr Oracle DBA Desk: (615) 762-1376
Asurion, Inc Mobile: (615) 517-2831
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 20 2008 - 15:26:55 CST
- application/ms-tnef attachment: stored