- 連接數(shù)據(jù)庫：
[xnie@szora1 ~]$ sudo su - oracle
[oracle@szora1 ~]$ lsnrctl start
[oracle@szora1 ~]$ sqlplus /nolog
SQL> connect / as sysdba;
- 查找被鎖信息：
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
------------------------------ ---------- ---------- ----------
SSTCORE 248 23 2016-08-03
- 解鎖：
SQL> alter system kill session '248,23';
