Re: NOT COMPLETE LOG

From: salu Ullah <salu_ullah_at_hotmail.com>
Date: Wed, 07 Feb 2001 11:19:53 -0800
Message-ID: <F001.002ADCBD.20010207081701@fatcity.com>

Hello Waleed.

Set the follwoing parameters.

LOG_CHECKPOINT_INTERVAL >= the number of OS blocks identical to the redo log file size. It starts a checkpoint only on each switched log file.
LOG_CHECKPOINT_TIMEOUT = 0. This disables the checkpointing based on time interval.

After these two parameters are set correctly, only the switch of a redo log starts a new checkpoint. A correct frequency is normally between 15 and 30 minutes. If its below, then increase the size of redo logs.

Salu

>From: "Waleed Haggagy \( Nile Networks \)" <Whaggagy_at_NileNetworks.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: NOT COMPLETE LOG
>Date: Wed, 07 Feb 2001 05:00:53 -0800
>
>MY DB 8.1.6 ON 3 SERVERS WORK WITH OAS
>DURING FOLLOW UP MY ALERT LOG FOUND LINES
>
> 'CHECKPOINT NOT
>COMPLETE'
> 'Thread 1 cannot
>allocate
>new log, sequence 609'
>
> WHY?
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Waleed Haggagy \( Nile Networks \)
> INET: Whaggagy_at_NileNetworks.com
>
>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).

Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: salu Ullah
  INET: salu_ullah_at_hotmail.com

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 Feb 07 2001 - 13:19:53 CST