oracle
死锁的话
用SELECT * FROM V$SESSION;找到已经断线的SESSION, 记下SID和SERIAL#的值; 用ALTER SYSTEM KILL SESSION 'SID, SERIAL#'杀死该SESSION.
重起oracle
[rootlocalhost ~]# su oracle
[oraclelocalhost root]$ sqlplus '/as sysdba'
oracle
死锁的话
用SELECT * FROM V$SESSION;找到已经断线的SESSION, 记下SID和SERIAL#的值; 用ALTER SYSTEM KILL SESSION 'SID, SERIAL#'杀死该SESSION.
重起oracle
[rootlocalhost ~]# su oracle
[oraclelocalhost root]$ sqlplus '/as sysdba'