My assumption is that you have a few ( maybe three or less ) little redo
logs. I think for most of systems 3min is a high frequency (maybe except
huge OLTP systems). The possible problem is that oracle begins checkpoint
event on the first redo log and then switch to the next log sequentially
until your first redo log. The checkpoint hasn't completed to that time, so
oracle waits until the end of checkpoint.
Please, run the script and check size of your redo logs:
--
-- Shows redo log information
--
prompt Abbreviations:
prompt gr# = group# thr# = tread# seq# = sequence#
set linesize 120
col "file name" format a45
col gr# format 999
col thr# format 999
col seq# format 999999
col members format 999999
col bytes format 99999999
select f.group# "gr#",
f.member "file name",
l.thread# "thr#", l.sequence# "seq#", l.bytes, l.members,
l.archived, l.status
from v$logfile f, v$log l
where f.group# = l.group#
/
Increase size of your redo log files, if it's necessary
Also, if you don't worry about recovery time, increase
log_checkpoint_interval to number of OS blocks greater than size of your
redo log file. It will force oracle to generate checkpoints only while redo
log switching
Sorry my English,
Ed
>
> Log_checkpoint_interval : 10000
> Log_checkpoint_timeout : 0
>
> About 3 mins between each : Thread 1 advanced to log ...
> How do I check the frequency of checkpoints ??? How do I
> check the size of
> the redo logs ???
>
> Sorry if I'ma sking basic questions but I'm starting a
> training in DBA
> tomorrow :-)
>
> > -----Original Message-----
> > From: Shevtsov, Eduard [SMTP:EShevtsov_at_flagship.ru]
> > Sent: Wednesday, October 04, 2000 10:25 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Thread 1 cannot allocate new log
> >
> > Hi
> >
> > You should check frequence of checkpoints and switching of
> you redo logs.
> > How many redo logs do you have? What is the size of redo
> logs? And what
> > about parameters log_checkpoint_interval, log_checkpoint_timeout ?
> >
> >
> >
> > Ed
> >
> > >
> > >
> > > Hi,
> > >
> > > I find frequent references of a similar error in my alert.log :
> > >
> > > Thread 1 cannot allocate new log, sequence 21539
> > > Checkpoint not complete
> > >
> > > How bad is this, and what can I do about it ???
> > >
> > >
> > > Greets,
> > >
> > > Kirsten
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Weerd Kirsten, E.C. de
> > > INET: Kirsten.deWeerd_at_Oranjewoud.nl
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> > > San Diego, California -- Public Internet access /
> > > Mailing Lists
> > >
> --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed
> from). You may
> > > also send the HELP command for other information (like
> subscribing).
> > >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Shevtsov, Eduard
> > INET: EShevtsov_at_flagship.ru
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access /
> Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like
> subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Weerd Kirsten, E.C. de
> INET: Kirsten.deWeerd_at_Oranjewoud.nl
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access /
> Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Wed Oct 04 2000 - 05:48:34 CDT
