Warning In Check DB

[Former Member]

Hello Guru's

Vital Information About Server

Database - ORACLE - 10.2.0.2.0

O/s - Windows NT - 5.2

SAP - Netweaver 04 - XI Server

kernel Information - Patch Level - 129

I am facing problem in my production server.

In DB13 - Check DB job we are facing problem since very long time

BR0978W Database profile alert - level: WARNING, parameter: DB_FILE_MULTIBLOCK_READ_COUNT, value: 128 (> 32)

BR0978W Database profile alert - level: WARNING, parameter: LOG_BUFFER, value: 2854912 (>< 2048,512 KB)

BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_FEATURES_ENABLE, value: 10.2.0.2 (<> 9.2.0)

BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_INDEX_COST_ADJ, value: 20 (<> 10)

BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_MODE, value: ALL_ROWS (<> CHOOSE)

Please suggest me so that I can rectify this problem.

Thanks & Regards

Shishir

[Former Member]

Thanks

[markus_doehr2]

check note

900522 - Incorrect alerts/warnings in database check for Oracle 10g

Markus