oracle下查看锁表进程
oracle下查看锁表进程
查询sessionId
SELECT object_name || ',' || machine || ',' || s.sid || ',' || s.serial#,sql_id
FROM v$locked_object l, dba_objects o, v$session s
WHERE l.object_id = o.object_id www.2cto.com
AND l.session_id = s.sid;
杀死进程id
alter system kill session '200,17209';
作者 myc
oracle下查看锁表进程 
