Home » RDBMS Server » Networking and Gateways » SQL errors seen on the network
SQL errors seen on the network [message #66197] Tue, 22 January 2002 05:53 Go to next message
Richard Jackson
Messages: 2
Registered: January 2002
Junior Member
Hi,
I don't know Oracle, I'm a networking guy. I've been watching some of our Oracle apps on the network and see a lot of errors. One app spend hours cycling through 4 packets; 1)OFETCH - Fetch row 2)Row transfer header 3)OEXEC - Execute statement 4)Error return status.

The sequence number and cursor number change with each fetch request so its not looping. Its more like its stepping through a table a wasting a lot of time and processing power on rows it doesnt need. Does this seem normal?

Can anyone point to a reference that describes sql network activity, what is normal, bad and signs of bad programming?
Re: SQL errors seen on the network [message #66324 is a reply to message #66197] Wed, 03 April 2002 06:13 Go to previous message
Richard Jackson
Messages: 2
Registered: January 2002
Junior Member
oh well
Previous Topic: Re: Can't Install 8i Client on Pentium 4 , NT 4 machine workaround
Next Topic: listener
Goto Forum:
  


Current Time: Wed Feb 28 03:21:11 CST 2024