|
Hi ,
I have a problem.
I wrote an
sql : in TERMINAL A
select col1,col2
from tableX
where col1 = ...
for update
I wrot same sql , in other terminal TERMINAL
B
select col1,col2
from tableX
where col1 = ...
for update
Then , I immidiately power
off Terminal A. In other words connection is closed without rollback or commit.
But , terminal B waits.. !!!! what is
the problem ?
TABLE ROW LOCK is not
AUTOMATICALLY killed.
I used , KILL SESSION to kill session. But
in my oppinion ORACLE must do it. Because connection is
closed.
I want , oracle kill this type of lock. How can I set Oracle to kill this
kind of LOCK problems ?
please help
me.. |
- Lock Problem hamid alavi
- RE: Lock Problem Christopher Spence
- RE: Lock Problem Carle, William T (Bill), NLCIO
- Re: Lock Problem Riyaj_Shamsudeen
- lock problem Harvinder Singh
- Re: lock problem Christian Trassens
- Re: lock problem Ali TOYGAR
- Re: lock problem Stephane Faroult
- Fw: lock problem Ali TOYGAR
- Re: lock problem hemantchitale
