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

[Former Member]

Hi,

Check . It may help you.

Thanks

Sushil

[Former Member]

Hi

You can set false according to note by using alter statement

but benificial if you set true/force for particular m-view query rewrite.

[Former Member]

Hello Ferhan,

What is the Oracle release?

Check these notes:Note 830576 (Parameter recommendations for Oracle 10g)

also, this will help you :

Additionaly, you can check thi link for Oracle database alerts:

http://help.sap.com/saphelp_nwmobile71/helpdata/de/45/e4ff4165b66976e10000000a1553f6/frameset.htm

thanks,

Prasanna

Edited by: Prasanna K on Jul 6, 2009 2:13 PM

[Former Member]

Hi Prasanna,

version :10.2.0.2.0

thanks.

Ferhan