RE: Thread 1 cannot allocate new log

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Wed, 4 Oct 2000 10:59:29 +0100
Message-Id: <10639.118439@fatcity.com>

I have always been led to believe that a checkpoint once every hour is about the right interval. You can check the frequency of a checkpoint by checking the trace file in -

ORACLE_HOME/RDBMS%/Trace/sidCKPT.trc

This gives you the timestamps of when a checkpoint occurred, you need to work the rest out :)

To check the size/status etc of your logs you need to look in v$log -

SQL> select * from v$log;

    GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM

---------- ---------- ---------- ---------- ---------- --- ---------------- 
------------- ---------
         1          1        393    1048576          1 NO  INACTIVE
2867873 03-OCT-00
         2          1        394    1048576          1 NO  CURRENT
2888037 04-OCT-00
         3          1        391    1048576          1 NO  INACTIVE
2827725 01-OCT-00
         4          1        392    1048576          1 NO  INACTIVE

2847757 02-OCT-00 This will also give you the current log file also. And before I get any messages about my logs being ridiculous - it's an empty test instance:)

Cheers

Mark

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Weerd Kirsten, E.C. de
Sent: 04 October 2000 11:25
To: Multiple recipients of list ORACLE-L Subject: 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).

--
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 - 04:59:29 CDT