| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
