alert - QUERY_REWRITE_ENABLED

[#1]

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.

[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