查看oracle锁及解决办法

SQL> 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;
USERNAME SID SERIAL# LOGON_TIME
------------------------------ ---------- ---------- -----------
SYS 35 11 2015/3/26 1
SCOTT 5 19 2015/3/26 1


SQL> alter system kill session '35,11';

系统已更改。

SQL>

posted on 2015-03-26 17:44  遠離塵世の方舟  阅读(135)  评论(0编辑  收藏  举报

导航