Warning - Checkpoint not complete

[Former Member]

Hi,

We have been getting Checkpoint not complete warning in development every day when we run update chk. in DB13. It is completed succesffully with the above warning. To resolve this warning message, we tried by setting the parameters LOG_CHECKPOINT_INTERVAL = 0, LOG_BUFFER = 1048576. But still we are facing this problem. We have refered one note (79341) which talks about increasing the log file size. In production, the log file size is same development and there is no other difference, but it is getting completed succesffully in prd. But in development it is giving this warning.

Can any one suggest on this?

Regards.....Iyy

[Former Member]

Hello,

A Checkpoint is a database event which synchronizes the modified data blocks in memory with the datafiles on disk.Depending on the number of datafiles in a database, a checkpoint can be a highly resource intensive operation.

If FAST_START_MTTR_TARGET is specified, LOG_CHECKPOINT_INTERVAL should not be set or set to 0.

To your concern between Prod and Dev you need to look in to redo logs switch how frequently it is.Then you can look in to actions.

Checkpoint not complete in Dev might be becoz DBWR writes too slowly, or log switch happens before the log is completely full.

So it depends on database activity.So ou can consider option of resizing logfile.

Regards

Vinod

[Former Member]

which OS and oracle DB version you are using.

cheers,

-Sunil

[Former Member]

Hi,

It is oracle 9i , os is solaris.

regards...Iyy