LOG_CHECKPOINT_INTERVAL parameter in SAP

[Former Member]

Hi all,

our SAP version is 4.7E and Oracle 9.2.0.7.In init(sid).ora parameter file

LOG_CHECKPOINT_INTERVAL value is " 0".

Please give your valuable suggestion about what is the exact value and will it effect on performance?

Regards

nani

[Former Member]

Hi,

LOG_CHECKPOINT_INTERVAL parameter specifies the maximum number of redo blocks the incremental checkpoint target should lag the current log tail.

If FAST_START_MTTR_TARGET is specified, LOG_CHECKPOINT_INTERVAL should not be set or set to 0. Since Oracle 9i FAST_START_MTTR_TARGET parameter is the preferred method of tuning incremental checkpoint target.

Regards

Vinod

[Former Member]

Hi Vinod,

Thanks for your reply.

In our int(sid).ora ,the FAST_START_MTTR_TARGET value is "0".

what is recommended value for LOG_CHECKPOINT_INTERVAL .

Regards

Nani

[Former Member]

Hi

LOG_CHECKPOINT_INTERVAL =0,

Check note 124361,488195

LOG_CHECKPOINT_INTERVAL 3000000000 (<= 8.0.6)

0 (>= 8.1.5)

Vinod

[Former Member]

Hi Vinod,

Our oracle is 9.2.0.7 and SAP 4.7E.

What is the recommende value ?

Thanks for your help

Regards

Nani

[fidel_vales]

Hi,

I think that Vinod gave you a good and nice answer, perhaps you need a bit of colour:

<quote>

Hi

LOG_CHECKPOINT_INTERVAL =0,

Check note 124361,488195

<b>LOG_CHECKPOINT_INTERVAL 3000000000 (<= 8.0.6)

<u><i>0 (>= 8.1.5)</i></u></b>

Vinod

</quote>