Re: Network trace of Oracle stored procedure result

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Thu, 16 Jun 2005 23:57:16 +0200
Message-ID: <42b1f5bd$0$25985$ba620e4c@news.skynet.be>

"Al Brown" <usenet_at_hotmail.com> wrote in message news:42b1f20c$0$41911$ed2619ec_at_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.
>

Couldn't this be the header of the PL/SQL package ? How do you execute the procedure ?

> 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:57:16 CDT