cancel
Showing results for 
Search instead for 
Did you mean: 

check database

former_member829550
Active Participant
0 Kudos

hi all,

when i perform the database check option in db13 it is being ended with warnings.

the warnings are for some parameters ::::::

BR0978W Database profile alert - level: WARNING, parameter: LOG_BUFFER, value: 14266368 (>< 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)

would anyone help in this....

regards,

bhupesh

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Check the relevant note for oracle param settings for your system as these are all common param changes (that should have been modified after upgrade!) Compare your current settings to the note. IF you still wish to have differing params than SAP suggest (your choice) then look in DB17 for the alerts.

I have listed my SUGGESTED answers below ... but please get the relevant SAP note and confirm these first.

regards

Scott.

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

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

This parameter should no longer be set (with your DB version)

alter system reset optimizer_features_enable scope = spfile sid='*';

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

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

alter system set parallel_execution_message_size = 16384 scope = spfile sid='*';

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

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

alter system set query_rewrite_enabled=false scope = spfile sid='*';

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

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

alter system set replication_dependency_tracking = FALSE scope = spfile sid='*';

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

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

alter system set star_transformation_enabled = TRUE scope = spfile sid='*';

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

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

alter system reset statistics_level scope = spfile sid='*';

Answers (2)

Answers (2)

former_member829550
Active Participant
0 Kudos

thanks

JPReyes
Active Contributor
0 Kudos

Simply you are getting warining because the check parameters thresholds in DB17.

Check and adjust thresholds and the warining will be gone.

Regards

Juan