error in SQL Monitoring screen 11.2.0.3.4
- From: John Hurley <hurleyjohnb@xxxxxxxxx>
- To: Oracle-L Freelists <Oracle-L@xxxxxxxxxxxxx>
- Date: Mon, 11 Mar 2013 13:46:55 -0700 (PDT)
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!
--
//www.freelists.org/webpage/oracle-l
Other related posts:
