This is hugely irritating, and I guess it may be a
version-dependent thing, but I can't get the exact
match for the quoted locks by setting up three
tables in the manner described.
The locking information varies between 8.1.7.3
and 9.0.1.3, but I can't get a PK/FK issue to
behave (mis-behave ?)
I have been spending most of my morning trying to resolve a locking issue. I think
I could me missing the forest for the trees. This is what happens: a user kicks off
two identical jobs from two different PCs. Each of these jobs is doing the same
thing, but against different rows of data
Jay
It looks like the application is locking the FIXED_ASSET_ACTIV
exclusive. Is the application written in Visual Basic and they are
issuing a SELECT FOR UPDATE clause?
The developers here loved the clause even if it wasn't the table they
were updating. It sounds reasonableI'm doing an
-Original Message-
From: Jay Hostetter [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:58 AM
To: Multiple recipients of list ORACLE-L
Subject: Help with Locking Issue
I have been spending most of my morning trying to resolve a locking
issue. I think I could me missing
Cool! Happy querying...
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: Jay Hostetter [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 1:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Help with Locking Issue
I had already checked
Any bitmap indexes on the table ?
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Author of:
Practical Oracle 8i: Building Efficient Databases
Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
with Locking Issue
I have been spending most of my morning trying to resolve a
locking
issue. I think I could me missing the forest for the trees. This is
what
happens: a user kicks off two identical jobs from two different PCs.
Each
of these jobs is doing the same thing, but against