Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Oracle Processes Stalling Problem
I am currently attempting to track down a very puzzling bug in a oracle
accessing system.
The problem is that after a certain period of time the entire thing
hangs up. This is based on Oracle 7.2.3 running on a HP 10.20 box with
all the relevant recommended patches installed.
The system itself comprises of a total of 44 tables which are accessed
by a number of different processes (the database access is done using
Pro C). The stall alwasy seems to occur on a SELECT FOR UPDATE on a
particular table. The table in question is simply a counter containing
three rows, which are updated by three seperate processes (and accessed
but not altered by a fourth) after they have completed their relevant
tasks. Has far as I can tell there are no conflicting locks, Oracle
itself returns no deadlock or other error and the problem still occcurs
when the NOWAIT parameter is included.
This has had myself and Oracle support stumped for a while now. I have
sent them all the trace logs and relevant lock table output etc so it is
nothing obvious.
I would appreciate any insight anyone can offer.
Thanks
Rob
Received on Wed Jan 27 1999 - 08:28:30 CST