Mysql、Oracle锁表处理

MySql解锁方式

# 1. 查看当前数据库锁表的情况 
SELECT * FROM information_schema.INNODB_TRX; 
# 2. 杀掉查询结果中锁表的trx_mysql_thread_id 
kill trx_mysql_thread_id

Oracle解锁方式

# 查看被锁的表
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';