Re: Network trace of Oracle stored procedure result

Al Brown wrote:

> It just seems very bizzarre thta you get a 90k payload for a 15 byte answer.
> OVer a WAN link this is making a 7 fold increase in response times. MS SQl
> does not seem to suffer from this.

Yeah, but then you need to compare apples with apples. SQL server not suffering from this means jack nothing.

To get an accurate network sniff for Oracle client-server traffic, run SQL*Plus on the client. E.g.

c:\> sqlplus /nolog
SQL> connect username/password_at_tnslias
connected
SQL> select FOO from FOO_TAB where FOO_ID = 1; ..
SQL> exit

Unsure what the physical filename of SQL*Plus command line executable is on Windows. But the above is a fair representation of the sequence of what the Windows client should be doing.

Note that SQL*Plus does make a couple of "hidden" SQL calls when connecting. This is because you can use a different version SQL*Plus with an Oracle server - so it does a sanity check when it connects to an Oracle server.

--
Billy