RE: Rapid Log Switching

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@xxxxxxxxx] 
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@xxxxxxxxxxx <mailto:John.Weatherman@xxxxxxxxxxx> > wrote:

All,

 

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.

 

TIA,

 

John

 

John P Weatherman    john.weatherman@xxxxxxxxxxx
<mailto:john.weatherman@xxxxxxxxxxx> 

Sr Oracle DBA            Desk:   (615) 762-1376

Asurion, Inc                Mobile: (615) 517-2831

Other related posts: