Can you give the exact db version please?
Apart from searching among know bugs on your behalf, there's not much thing to work on in what you've given us so far.
Could you share the query ? What about the volume of data ?
Strange, never got notified that anyone replied. Oracle version is:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Volume of data is not large.
XMLELEMENT ("PFTYP_NAME", PFTYP_NAME),
FROM (WITH TEST_TREE AS..
Can't share the exact query but it's using a WITH clause which contains a query using a CONNECT BY NOCYCLE. There are several UNION ALLs of the result set generated by the WITH clause.
Thanks for your help!
Message was edited by: user12110856