Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Oracle Processes Stalling Problem

Oracle Processes Stalling Problem

From: Robert Pritchard <robert_pritchard_at_tertio.com>
Date: Wed, 27 Jan 1999 14:28:30 +0000
Message-ID: <36AF228E.20B40FC8@tertio.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US