Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Q about wait SQL*Net message from client
I have a Pro*C program that is constantly causing a blocking lock when it performs an update. The code is very simple, In the code loop where the update occurs, it performs the update, then commits and exits the loop. (Server 7.3.2.3)
When looking at the v$session_wait for this session, it constantly says "SQL*Net message from client" as the wait. What does this really mean? I suspect there is something else, Everyone in my shop is convinced that there is a problem with the server or SQL-Net causing this problem, but it is always this program. I need some help honing in on what else might be causing this. The program code looks solid, and ran fine for 6 months since the last code change. This locking issue has been a problem for the last few weeks.
The only changes made were some foreign keys added. But, these columns are indexed, so the server should be able to avoid a table lock.
Any pointers are greatly appreciated.
Joe
Received on Sat Sep 20 1997 - 00:00:00 CDT
![]() |
![]() |