error in SQL Monitoring screen 11.2.0.3.4
Date: Mon, 11 Mar 2013 13:46:55 -0700 (PDT)
Message-ID: <1363034815.6806.YahooMailClassic_at_web181205.mail.ne1.yahoo.com>
Anyone seen this?
I have a query that uses a text index ( catsearch ). When it gets picked up for real time SQL Monitoring in 11.2.0.3.4 and you click on the sqlid ... OEM screen throws an error and does not display the SQL and of course does not display the SQL monitoring report.
Works just fine in 11.1.0.7.12 ( really all the 11.1.0.7.x versions ).
Text returned in OEM monitoring screen looks like this:
java.sql.SQLException: ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00225: end-element tag "bind" does not match start-element tag "query" Error at line 1
ORA-06512: at "SYS.DBMS_SQLTUNE", line 13969 ORA-06512: at "SYS.DBMS_SQLTUNE", line 14265 ORA-06512: at line 1
SQL involved looks like this:
SELECT /*+ index(VS_CUSTOMER CUSTOMER_SX1) */ IMAGE_RECNBR, CUSTOMER_ID, CONTROL_SEQ_ID, CUSTOMER_ID_NEW, NAME_LAST, NAME_FIRST, ADDRESS_1, ADDRESS_2, ADDRESS_3, CITY, STATE, ZIP, QTY_FIXTIME_INQUIRY, AB_COVER, FDX_SIGNATURE_RELEASE, DATE_SHIP_FIRST, GOOD_RISK, OPT_IN_OUT, COD_RISK, CATALOG_PREF_1, CATALOG_PREF_2, CATALOG_PREF_3, CATALOG_PREF_4, CATALOG_PREF_5, CATALOG_PREF_6, FLAG_SHIP_PREF, DATE_MAIL_ORDER_FIRST, WEB_ONLY, LANGUAGE, AREA_CODE, PHONE_NBR, COUNTRY_ID, TAX_EXEMPT_ID, SOURCE_CODE_FIRST, SOURCE_CODE_LAST, DATE_TRANSACTION_FIRST, DATE_TRANSACTION_LAST, CNT_ORDER, TOT_NET_ORDER_AMT, FLAG_ORDER_TYPE, FLAG_NIXIE, FLAG_NOMAIL, FLAG_PROMO, FLAG_FRAUD, FLAG_COD, FLAG_REFUSED, FLAG_CATALOG, FLAG_SHIP_TO, FLAG_DELETE, FLAG_BUSINESS_CUSTOMER, FLAG_CASH_CHECK
FROM sre_corp.VS_CUSTOMER
WHERE ((catsearch(NAME_LAST,:"SYS_B_0",NULL) > :"SYS_B_1")) ORDER BY IMAGE_RECNBR
***
I have a bad feeling I need to submit an SR ... dang!
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 11 2013 - 21:46:55 CET