10g Automatic Checkpoint Tuning

From: Raj Mareddi <yoursraju007_at_gmail.com>
Date: Mon, 25 Jun 2007 17:09:44 -0400
Message-ID: <7f411f4e0706251409t4b7bc05fw2e37ab09c1e37e3d@mail.gmail.com>

Guys,

The following are the top-4 waits after CPU Time in my AWR reports during a batch window.

log file switch (checkpoint incomplete)
free buffer waits
log file switch (private strand flush incomplete) log file parallel write

Just realized that log switches are happening very frequent.. each log member is 300M and 3 groups. this size seems to be okay.. other database has 100M member and the same batch job runs good there. First wait says, checkpoint incomplete.. I have started looking at checkpoint tuning.. I have uncommented the following parameters

• LOG_CHECKPOINT_INTERVAL
• LOG_CHECKPOINT_TIMEOUT

and set FAST_START_MTTR_TARGET to 60... Still dint see any big difference. Has anyone started using FAST_START_MTTR_TARGET for automatic checkpoint tuning ? Document says if we just need checkpoint tuning, we need to set this higher.. but it doesn't say how higher.. Im thinking of going back to old boat of setting using interval value or FAST_START_MTTR_TARGET to a very high no#. . Any comments please.

Automatic Checkpoint Tuning in 10g: 265831.1 REDO LOGS SIZING ADVISORY: 274264.1

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 25 2007 - 16:09:44 CDT