Selecting through XMLSerialize( {xmltype column} )
924065Sep 17 2012 — edited Sep 24 2012In JDBC, while retrieving the XmlType column, we tried out using two ways
a) Use XmlSerialize( CONTENT {XmlColumn} ) in the SQL-Query and retrieve it as CLOB in Java. This is faster, but it truncates the un-necessary precision data in numeric values. For example, this returns 0.625 as .625.
b) Use {XmlColumn} in the SQL-Query and retrieve it as SQLXML in Java. This returns the data, as we have stored it, but it is 2x slower than the above approach on an average.
Is this the expected behavior (or) something can be changed to provide better performance with approach 2?
In SQLPlus, when i try to see the autotrace stats, its getting hung while i don't do XmlSerialize.
Oracle Version : 11.2.0.3
Thanks,
Gokul.
Edited by: KSGokul on Sep 17, 2012 2:23 AM