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..

Reply via email to