Skip to Content
0
Former Member
Jun 25, 2009 at 04:32 AM

DB check warnings & errors

497 Views

Hi all,

When i am doing a Database check I am getting following errors & warnings.

Why this 2 errors occur even on fresh SAP system ...

-*****************************************************************************************************************

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)

***********************************************************************************************

What recommendations i can take when my profile parameters are in warning.

**************************************************************************************************************

BR0976W Database message alert - level: WARNING, line: 395408, time: 2009-06-16 11.25.45, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 395420, time: 2009-06-16 11.26.02, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 395432, time: 2009-06-16 11.26.18, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 396608, time: 2009-06-19 12.10.40, message:

Checkpoint not complete

BR0976W Database message alert - level: WARNING, line: 396627, time: 2009-06-19 12.11.07, message:

Checkpoint not complete

BR0280I BRCONNECT time stamp: 2009-06-23 03.01.06

BR0977I Checking database profile...

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

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 advice me on the following

regards

rahul