Re: XML queries and Excessive Network Traffic

From: Jared Still <jkstill_at_gmail.com>
Date: Sun, 20 Jul 2014 19:14:57 -0700
Message-ID: <CAORjz=OzbCBXqit_YrZBKZBJLiasHv=DeYU+h3QdLkreQz5MJg_at_mail.gmail.com>

On Fri, Jul 18, 2014 at 2:29 PM, Seth Miller <sethmiller.sm_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 21 2014 - 04:14:57 CEST