RE: Thread 1 cannot allocate new log

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).
Received on Wed Oct 04 2000 - 05:22:42 CDT