Performance of XMLType conversion

From: <spammerswillbeshot_at_yahoo.com>
Date: 23 Nov 2004 07:29:11 -0800
Message-ID: <172e8784.0411230729.6bfaa5a2@posting.google.com>

Running Release 9.2.0.4.0, new to XML.
I am using DBMS_XMLgen.getXML(myContextHandle) to return a cursor as XMLType or formatted Clob. The cursor itself runs in less than 1 sec. However, the getXML boosts the time to 35 seconds.

Is this a typical "cost of using XML"? Anyone else experience this type of overhead in converting a cursor to XMLType? Is there a "faster" DBMS package or approach that gives better performance than DBMS_XMLgen?

Thanks!!
Gordon
spammerswillbeshot_at_yahoo.com Received on Tue Nov 23 2004 - 09:29:11 CST