RE: checkpoint not complete

Andreas

Checkpoints help to reduce the amount of time needed to perform instance recovery.Checkpoint cause DBWR to write all the blocks that have been modified since the last checkpoint to the datafiles and update the datafiles header and controlfiles to record the checkpoint.Checkpoints occur automatically whem an online redo log file fills;the LOG_CHECKPOINT_INTERVAL parameter in the database instance's init.ora file may be used to set a more frequent checkpoint.

 Now you can decrease the LOG_CHECPOINT_INTERVAL parameter in your init.ora parameter for more frequent checkpointing.

Vikas
-----Original Message-----
From: Andreas Jung [mailto:ajung_at_sz-sb.de] Sent: Monday, May 29, 2000 8:36 PM
To: Multiple recipients of list ORACLE-L Subject: checkpoint not complete

During resync my Intermedia indexes I often see a "checkpoint not complete" message in my alert file.

What does it mean ?

Andreas

-- 
Author: Andreas Jung
  INET: ajung_at_sz-sb.de

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).