> 1) why so much more traffic for the same data?
As I earlier wrote, since xmltypes stores as lobs, they are also
transmitted as lobs through locator, so every xmltype requires additional
SQL*Net roundtrip.
> 2) what can we do about it?
I know only 3 options:
1. To get small xml through xmlserialize(as varchar2(4000)) or deprecated
.getstringval()
And LOB optimizations:
2. OCI: Usage of OCILobArrayWrite/OCILobArrayRead:
http://docs.oracle.com/cd/E18283_01/appdev.112/e10646/oci07lob.htm#i444270
http://docs.oracle.com/cd/E18283_01/appdev.112/e10646/oci07lob.htm#CHDDHFAB
3. OJDBC: Lob prefetching:
http://oracle.su/docs/11g/java.112/e10589/oralob.htm#CHDGDGBA
--
Best regards,
Sayan Malakshinov
http://orasql.org
