MySQL解锁方式:
# 1. 查看当前数据库锁表的情况
SELECT * FROM information_schema.INNODB_TRX;
# 2. 杀掉查询结果中锁表的trx_mysql_thread_id
kill trx_mysql_thread_id
Oracle解锁方式:
# 查看被锁的表ct
select b.owner, b.object_name, a.session_id, a.locked_mode
from v$locked_object a, dba_objects b where b.OBJECT_ID = a.OBJECT_ID
# 查看连接的进程
select sid, serial#, username, osuser from v$session;
# 杀掉进程 sid, serial#
alter system kill session ‘678,983’;