XMLAGG in XMLDB network transfer
Hi All
We are using oracle XML DB 11.2.0.3 and storing XML's as XMLTYpe.While sending the data we are using XMLAGG to collect all the xml and convert to Clob and send the data to the application client.is there any best practise to follow from orcle xml DB while transfering the data from oracle to application.
we are using linux env with Oracle RAC 2 Node.
Current limit is 4MB - RECEIVE and 2 MB - SEND in the TCP IP buffer size.