Re: XML queries and Excessive Network Traffic
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Sat, 19 Jul 2014 01:17:30 +0400
Message-ID: <CAOVevU7VYinvTtCMQK3QAB6fgq4UmXXdm22PO2OSQtT0gpFEDA_at_mail.gmail.com>
AFAIK, xmltype transports as clob, so I think, it's just a result of getting xmltypes by locator through additional sql*net roundtrip per each xmltype.
Date: Sat, 19 Jul 2014 01:17:30 +0400
Message-ID: <CAOVevU7VYinvTtCMQK3QAB6fgq4UmXXdm22PO2OSQtT0gpFEDA_at_mail.gmail.com>
AFAIK, xmltype transports as clob, so I think, it's just a result of getting xmltypes by locator through additional sql*net roundtrip per each xmltype.
--
Best regards,
Sayan Malakshinov
Senior performance tuning engineer
PSBank
http://orasql.org
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jul 18 2014 - 23:17:30 CEST