Home » RDBMS Server » Performance Tuning » Tuning help:-URGENT
Tuning help:-URGENT [message #65663] Thu, 25 November 2004 19:04
Milind Deshpande
Messages: 93
Registered: May 2004
Member
Hello Experts,

I am working on this query which is taking to much time to execute and requires to be tuned and it is giving error at the time of execution:-

ERROR at line 1:

ORA-31011: XML parsing failed

ORA-19202: Error occurred in XML processing

LPX-00241: entity reference is not well formed

Error at line 1

The query is like this :-


select

TDI.DI_ID
from
TDI TDI
where TDI.DI_INFO.Extract('/DI/Isconditional/text()').getStringVal() is not null and DI_TYPE_CD <> 11004;

I think the error is due to XML datatype in the Table.

Table description:-

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------
 DI_ID                                     NOT NULL NUMBER(18)
 DI_TYPE_CD                                NOT NULL NUMBER(9)
 IS_CONDITIONAL                            NOT NULL CHAR(1)
 IS_CONVERTED                              NOT NULL CHAR(1)
 DI_INFO                                   NOT NULL SYS.XMLTYPE
 CREATED_BY                                NOT NULL VARCHAR2(25)
 CREATED_DATE                              NOT NULL DATE
 LAST_MODIFIED_BY                          NOT NULL VARCHAR2(25)
 LAST_MODIFIED_DATE                        NOT NULL DATE

Explain plan:-

SELECT STATEMENT, GOAL = FIRST_ROWS   43638 107103 121990317  
 TABLE ACCESS FULL ARROW TDI 43638 107103 121990317  

Can anybody tell me what can be done in this case because Oracle doesnt allow me to create  the Index on XML datatype column.

Pls. tell me anyway that this problem can be solved.

If any table has to be created or anything you people can suggest Please this urgent.

Thanks in advance

Milind.
Previous Topic: ORA-0430 Error for SQL
Next Topic: PL/SQL commit
Goto Forum:
  


Current Time: Sun Sep 20 22:38:06 CDT 2020