oracle可以有几个账号密码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 '2oracle账号00,17209'; 

作者 myc