db_block_checksum

[Former Member]

Hi All,

In one of my system, there is a warning in brconnect check with regard to db_block_checksum :

-

---

BR0978W Database profile alert - level: WARNING, parameter: DB_BLOCK_CHECKSUM, value: TRUE (<> FALSE)

-

---

I had check db17, the setting value in FALSE. So i assume that if the parameter in the db is set to TRUE, i will get this warning message. In oracle when i "show parameters db_block_checksum", the return value is TRUE

My question is

1) This same setting applied to all my other 7 servers. However, i only get this warning in one of the server, what happen to other servers? Why this warning does not appear in the other servers?

2)In OSS, SAP recommend the value to be set to FALSE so that it will not cause any performance issue. How do I set the value from TRUE to FALSE?

Regards

Lauran

[Former Member]

Hi,

I dont really get what you mean

In Db17, my value is already set as FALSE. This setting apply to all my others server and is activated

Regards

Lauran

[Former Member]

Hello,

did you examine this oss note:

Note 923919 - Advanced Oracle block checking features

"Turning off this feature is up to each customer. SAP recommends in the standard parameter notes to enable checksums by removing the db_block_checksum parameter from the parameter file so that the default 'TRUE' is taken."

regards,

[Former Member]

alter system set db_block_checksum=<value> scope=both;

[JPReyes]

Then check your spfile as the value must be set to TRUE.

Regards

Juan

[JPReyes]

If the parameter is right... then just go to DB17, mark DB_BLOCK_CHECKSUM and change the condition from TRUE to FALSE... save it and the alert wont happen anymore.

Why this warning does not appear in the other servers?

Either the condition is already marked as FALSE or the condition just doesn't exit

Regards

Juan