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.
|
|
|
Goto Forum:
Current Time: Sat Jan 11 08:43:54 CST 2025
|