Re: Unnecessary Locks -- Help!

> But here comes the problem. We defined a foreign key from col of table > A to table B. Now even test case 2 got key value lock regardless > whatever values col is using. > > Can anyone explain it? Is it because repeatable read locks the > referenced table? Is there a way to avoid the locking yet still > maintain repeatable read? Chao, An important consideration regarding REPEATABLE READ is that it locks every row it *examines*, not every row that makes up the set. I don't know if it will be possible to achieve your goal and maintain REPEATABLE READ. HTH. -- Ciao, Billy +------------------------------------------------------------------------------+ | Billy Wheeler Junior Programmer / Director The West Solutions Group | +------------------------------------------------------------------------------+ | Oracle isn't the answer. Oracle is the question, and the answer is "no". | +------------------------------------------------------------------------------+