cancel
Showing results for 
Search instead for 
Did you mean: 

Check DB Errors

Former Member
0 Kudos

Dears,

We are facing below errors in CheckDB in DB13:

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

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

BR0978W Database profile alert - level: WARNING, parameter: MAX_DUMP_FILE_SIZE, value: UNLIMITED (>< 100000,10000)

BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_FEATURES_ENABLE, value: 10.2.0.1 (set in parameter file)

BR0978W Database profile alert - level: WARNING, parameter: PARALLEL_EXECUTION_MESSAGE_SIZE, value: 2152 (>< 16384,4096)

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

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

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

BR0978W Database profile alert - level: WARNING, parameter: STATISTICS_LEVEL, value: TYPICAL (set in parameter file)

Please suggest reason and solutions of the issue.

Shivam

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

please check the note Note 830576 - Parameter recommendations for Oracle 10g for the oracle parameters and also install the intrem patches based on that you change the oracle parameters. Also as Bhavik G. Shroff said check the note 900522.

Thanks,

Chaitanya.

Answers (1)

Answers (1)

former_member524429
Active Contributor
0 Kudos

Hi,

Please refer SAP Note 900522 - Incorrect alerts/warnings in database check for Oracle 10g along with other relative SAP Notes to get more relevant information.

You can customize such condition entries using DB17. Go there and identify the condition entries.

Also use latest version of BR*tools corresponding the SAP Kernel release.

Regards,

Bhavik G. Shroff