alert - QUERY_REWRITE_ENABLED

[Former Member]

hi,

i have a error alert that Value: TRUE (<> FALSE) # Allow rewrite of queries using materialized views.

and it's corrective action is Change the Oracle parameter.

have you got any idea?

thanks.

[JPReyes · Accepted solution]

Are you just posting every alert?... did you do any research before posting?...

[Former Member · Accepted solution]

yeah. i research it. but why it must be "false" on sap? and why now? the system is running at 2 years.

thanks.

[Former Member · Accepted solution]

yeah. i research it. but why it must be "false" on sap? and why now? the system is running at 2 years.

thanks.

Edited by: Ferhan Tekin on Jul 6, 2009 4:24 PM

[JPReyes · Accepted solution]

Did you upgraded your DB?.... did you check the Note 830576 and follow the recomendations?

If your parameters are correct set the right thresholds on DB17 and the alerts will be gone.

Regards

Juan