Advertisement
Guest User

Untitled

a guest
May 6th, 2015
213
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.23 KB | None | 0 0
  1. SELECT SESSION_ID
  2. FROM DBA_DML_LOCKS
  3. WHERE NAME = Table Name;
  4.  
  5. SELECT SID,SERIAL#
  6. FROM V$SESSION
  7. WHERE SID IN (SELECT SESSION_ID
  8. FROM DBA_DML_LOCKS
  9. WHERE NAME = Table Name)
  10.  
  11. ALTER SYSTEM KILL SESSION 'SID,SERIALl#';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement