Re: XML queries and Excessive Network Traffic

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: Seth Miller <sethmiller.sm@xxxxxxxxx>
  • Date: Sun, 20 Jul 2014 19:14:57 -0700

On Fri, Jul 18, 2014 at 2:29 PM, Seth Miller <sethmiller.sm@xxxxxxxxx>
wrote:

> getclobval() was deprecated in 11.2.0.1
> <http://docs.oracle.com/cd/E11882_01/appdev.112/e10492/whatsnew.htm#ADXDB5978>.
> Try using xmlserialize instead. I have seen major performance differences
> between these two functions.


Tried it just now - the performance was only marginally different that CLOB
or XMLType

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Sr Oracle DBA at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com

Other related posts: