ORACLE行级锁实验

 

  

 

 SELECT SID,
       SERIAL#,
       SQL_ID,
       PREV_SQL_ID,
       SCHEMANAME,
       PREV_EXEC_START,
       LOGON_TIME,
       LAST_CALL_ET,
       BLOCKING_SESSION,
       FINAL_BLOCKING_SESSION,
       EVENT
  FROM v$session
 WHERE status = 'ACTIVE' AND TYPE != 'BACKGROUND';

 SELECT sql_id,sql_text
  FROM v$sql
 WHERE sql_id IN ('5c7cw2g5ktwz2','1dp1gqvj7vanx','0xr41htrmgtnb','0jrsypfawkucx')

 SELECT  SELECT sql_id,sql_text
  FROM v$sql
 WHERE sql_id IN ('g17wpbdtc82yf','6349a1pv46n9f');

alter system kill session '31,533' immediate;

 

 

SELECT 'alter system kill session '||''''||SID||','||SERIAL#||''''||' immediate;'
  FROM v$session
 WHERE TYPE != 'BACKGROUND'
 and sid='33'
 
alter system kill session '33,241' immediate; 

alter system kill session '36,25' immediate;