1.管理员或者数据库查询哪些事务繁忙和已经锁
select t2.username,t2.sid,t2.serial#,t2.logon_time from v$locked_object t1,v$session t2 where t1.session_id = t2.sid order by t2.logon_time;
3.7条事务正在运行或者已经被锁,通过kill来结束进程
alter system kill session '193,22958';
1.管理员或者数据库查询哪些事务繁忙和已经锁
select t2.username,t2.sid,t2.serial#,t2.logon_time from v$locked_object t1,v$session t2 where t1.session_id = t2.sid order by t2.logon_time;
3.7条事务正在运行或者已经被锁,通过kill来结束进程
alter system kill session '193,22958';