Skip to Content
0
Former Member
Feb 06, 2015 at 03:31 PM

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

737 Views

Hello,

I alter this value with the follows command:

alter system set "optimizer_mode=all_rows" scope=both;

I run the CHECKDATABASE in tranx dbacockpit and appear the follow warning:

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

The oracle version is 11g (11.2.0.2.0)

How I can fix this warning?

Best Regards!