Question Re: alert - QUERY_REWRITE_ENABLED in Technology Q&A https://community.sap.com/t5/technology-q-a/alert-query-rewrite-enabled/qaa-p/5763865#M2132016 <HTML><HEAD></HEAD><BODY><P>yeah. i research it. but why it must be "false" on sap? and why now? the system is running at 2 years.</P><P>thanks.</P></BODY></HTML> Mon, 06 Jul 2009 14:10:12 GMT Former Member 2009-07-06T14:10:12Z alert - QUERY_REWRITE_ENABLED https://community.sap.com/t5/technology-q-a/alert-query-rewrite-enabled/qaq-p/5763860 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>i have a error alert that Value: TRUE (&lt;&gt; FALSE) # Allow rewrite of queries using materialized views. </P><P>and it's corrective action is Change the Oracle parameter. </P><P>have you got any idea?</P><P>thanks.</P></BODY></HTML> Mon, 06 Jul 2009 11:27:22 GMT https://community.sap.com/t5/technology-q-a/alert-query-rewrite-enabled/qaq-p/5763860 Former Member 2009-07-06T11:27:22Z Re: alert - QUERY_REWRITE_ENABLED https://community.sap.com/t5/technology-q-a/alert-query-rewrite-enabled/qaa-p/5763861#M2132012 <HTML><HEAD></HEAD><BODY><P>Hello Ferhan,</P><P></P><P>What is the Oracle release?</P><P></P><P>Check these notes:Note 830576 (Parameter recommendations for Oracle 10g)</P><P>also, this will help you : <A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="7756624"></A></P><P></P><P>Additionaly, you can check thi link for Oracle database alerts:</P><P><A href="http://help.sap.com/saphelp_nwmobile71/helpdata/de/45/e4ff4165b66976e10000000a1553f6/frameset.htm" target="test_blank">http://help.sap.com/saphelp_nwmobile71/helpdata/de/45/e4ff4165b66976e10000000a1553f6/frameset.htm</A></P><P></P><P>thanks,</P><P>Prasanna</P><P></P><P>Edited by: Prasanna K on Jul 6, 2009 2:13 PM</P></BODY></HTML> Mon, 06 Jul 2009 12:09:18 GMT https://community.sap.com/t5/technology-q-a/alert-query-rewrite-enabled/qaa-p/5763861#M2132012 Former Member 2009-07-06T12:09:18Z Re: alert - QUERY_REWRITE_ENABLED https://community.sap.com/t5/technology-q-a/alert-query-rewrite-enabled/qaa-p/5763862#M2132013 <HTML><HEAD></HEAD><BODY><P>Are you just posting every alert?... did you do any research before posting?...</P></BODY></HTML> Mon, 06 Jul 2009 12:28:13 GMT https://community.sap.com/t5/technology-q-a/alert-query-rewrite-enabled/qaa-p/5763862#M2132013 JPReyes 2009-07-06T12:28:13Z Re: alert - QUERY_REWRITE_ENABLED https://community.sap.com/t5/technology-q-a/alert-query-rewrite-enabled/qaa-p/5763863#M2132014 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>You can set false according to note by using alter statement</P><P>but benificial if you set true/force for particular m-view query rewrite.</P></BODY></HTML> Mon, 06 Jul 2009 12:46:26 GMT https://community.sap.com/t5/technology-q-a/alert-query-rewrite-enabled/qaa-p/5763863#M2132014 Former Member 2009-07-06T12:46:26Z Re: alert - QUERY_REWRITE_ENABLED https://community.sap.com/t5/technology-q-a/alert-query-rewrite-enabled/qaa-p/5763864#M2132015 <HTML><HEAD></HEAD><BODY><P>Hi Prasanna,</P><P>version :10.2.0.2.0</P><P>thanks.</P><P></P><P>Ferhan</P></BODY></HTML> Mon, 06 Jul 2009 14:08:33 GMT https://community.sap.com/t5/technology-q-a/alert-query-rewrite-enabled/qaa-p/5763864#M2132015 Former Member 2009-07-06T14:08:33Z Re: alert - QUERY_REWRITE_ENABLED https://community.sap.com/t5/technology-q-a/alert-query-rewrite-enabled/qaa-p/5763865#M2132016 <HTML><HEAD></HEAD><BODY><P>yeah. i research it. but why it must be "false" on sap? and why now? the system is running at 2 years.</P><P>thanks.</P></BODY></HTML> Mon, 06 Jul 2009 14:10:12 GMT https://community.sap.com/t5/technology-q-a/alert-query-rewrite-enabled/qaa-p/5763865#M2132016 Former Member 2009-07-06T14:10:12Z Re: alert - QUERY_REWRITE_ENABLED https://community.sap.com/t5/technology-q-a/alert-query-rewrite-enabled/qaa-p/5763866#M2132017 <HTML><HEAD></HEAD><BODY><P>yeah. i research it. but why it must be "false" on sap? and why now? the system is running at 2 years.</P><P>thanks.</P><P></P><P>Edited by: Ferhan Tekin on Jul 6, 2009 4:24 PM</P></BODY></HTML> Mon, 06 Jul 2009 14:24:19 GMT https://community.sap.com/t5/technology-q-a/alert-query-rewrite-enabled/qaa-p/5763866#M2132017 Former Member 2009-07-06T14:24:19Z Re: alert - QUERY_REWRITE_ENABLED https://community.sap.com/t5/technology-q-a/alert-query-rewrite-enabled/qaa-p/5763867#M2132018 <HTML><HEAD></HEAD><BODY><P>Did you upgraded your DB?.... did you check the Note 830576 and follow the recomendations?</P><P></P><P>If your parameters are correct set the right thresholds on DB17 and the alerts will be gone.</P><P></P><P>Regards</P><P>Juan</P></BODY></HTML> Mon, 06 Jul 2009 14:28:21 GMT https://community.sap.com/t5/technology-q-a/alert-query-rewrite-enabled/qaa-p/5763867#M2132018 JPReyes 2009-07-06T14:28:21Z Re: alert - QUERY_REWRITE_ENABLED https://community.sap.com/t5/technology-q-a/alert-query-rewrite-enabled/qaa-p/5763868#M2132019 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check <A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="7757879"></A>. It may help you.</P><P></P><P>Thanks</P><P>Sushil</P></BODY></HTML> Mon, 06 Jul 2009 14:44:41 GMT https://community.sap.com/t5/technology-q-a/alert-query-rewrite-enabled/qaa-p/5763868#M2132019 Former Member 2009-07-06T14:44:41Z