Databse alert warning / Error

[Former Member]

Dear All,

Followig datbase check warning observed in producion server.

Database profile alert - level: ERROR, parameter: FILESYSTEMIO_OPTIONS, value: DIRECTIO (<> SETALL)

Database profile alert - level: WARNING, parameter: LOG_BUFFER, value: 14501888 (>< 4096,512 KB)

Database profile alert - level: WARNING, parameter: OPTIMIZER_INDEX_COST_ADJ, value: 20 (set in parameter file)

Database profile alert - level: WARNING, parameter: TIMED_STATISTICS, value: TRUE (set in parameter file)

Please reply me How to correct this Warning / Error ?

Regards,

Santosh

[Former Member · Accepted solution]

Which DB version?

Oracle 10g: refer note 830576 for the right parameters and set it accordingly.

after setting parameters correctly according to the note, use Txn DB17 to switch off alters those are not valid

[former_member204746]

hi,

adapt these parameters as per SAP note 830576.

when finish, adapt DB17 with the same values.

Finally, check with SAP Note 1171650 - Automated Oracle DB parameter checkcheck

this will fix your issue.

[Former Member]

We are using Oracle 10.2.0.2.0 Version , on SAP ECC 6.0.

According this Note , If I change the Paramter FILESYSTEMIO_OPTIONS, value: DIRECTIO ( SETALL)

so , which are the dependable paramerer I have to change ?

Please reply me the same.

Regards,

Santosh