Oracle XDK Performance Issues

[KL1]

I am using the Oracle XDK to generate xml from the database. A straight forward select from 1 table which would pull back 70 records takes 10 mins to run before falling over as it has run out of tablespace in TEMP files.

I have run an explain plan on the select and the cost is only 1 and it is using the correct indexes.

I have raised a TAR with Oracle but they are of no help.

Does anyone have any experience of this? Any assistance would be appreciated as we have important deadlines to meet.

Thanks in advance.
Karen

 

[chiph]

I would simplify my query -- start off with a Select Count(*) from tbl_foo and see how well it produces XML (if at all).

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first