How To Throubleshoot Row Lock On Oracle 11g

* select count(*) FROM GV$SESSION WHERE EVENT like '%row lock%'; ########################

* select sql_id FROM GV$SESSION WHERE EVENT like '%row lock%'; #####################

* SELECT 'ALTER SYSTEM KILL SESSION '''||SID||','||serial#||',@'||INST_ID||''' IMMEDIATE;' FROM GV$SESSION WHERE sql_id='53hjjuwfhtuyy'; ###############

ALTER SYSTEM KILL SESSION '1708,15324,@1' IMMEDIATE;


----------------------
jika ada centention maka jalanin fungi di bawah ini setelah alter kill session sql id
select count(*) FROM GV$SESSION WHERE EVENT like '%contention%'; ########################

* SELECT 'ALTER SYSTEM KILL SESSION '''||SID||','||serial#||',@'||INST_ID||''' IMMEDIATE;' FROM GV$SESSION WHERE EVENT like '%contention%'; #################






-------------------------------------------------------------------------------------------------------------------
select * from gv$session where sql_id='53hjjuwfhtuyy';

select sid from gv$session where sql_id='53hjjuwfhtuyy';

* select count(*) FROM GV$SESSION WHERE EVENT like '%row lock%'; ########################

* select sql_id FROM GV$SESSION WHERE EVENT like '%row lock%'; #####################

select sql_text from gv$sqlarea where sql_id='53hjjuwfhtuyy';

SELECT NAME,POSITION,DATATYPE_STRING,VALUE_STRING FROM gv$sql_bind_capture WHERE sql_id='53hjjuwfhtuyy';

* SELECT 'ALTER SYSTEM KILL SESSION '''||SID||','||serial#||',@'||INST_ID||''' IMMEDIATE;' FROM GV$SESSION WHERE sql_id='53hjjuwfhtuyy'; ###############


--------------------
select count(*) FROM GV$SESSION WHERE EVENT like '%contention%'; ########################

* SELECT 'ALTER SYSTEM KILL SESSION '''||SID||','||serial#||',@'||INST_ID||''' IMMEDIATE;' FROM GV$SESSION WHERE EVENT like '%contention%'; #################