Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Network trace of Oracle stored procedure result

Network trace of Oracle stored procedure result

From: Al Brown <usenet_at_hotmail.com>
Date: Thu, 16 Jun 2005 21:41:36 GMT
Message-ID: <42b1f20c$0$41911$ed2619ec@ptn-nntp-reader03.plus.net>


I did a network trace yesterday for the results coming back from an Oracle 9.2 server running a stored procedure in a package. This was called from ADO from a windows 2003 server.

the expected resultant record set is a 15 byte customer id. The network trace shows that about 100 packets with a total size of 90K was sent to satisfy this one request. The preamble before you recieve any data was a list padded out with spaces of al lthe stored procedures and their names that were stored in tha package.

can anybody explain why this is and what can be done to stop it. The reason for doing this was because of a slow down in execution times when executing this over a 34MB Wan segment.

Thanks Received on Thu Jun 16 2005 - 16:41:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US