数据库知识库

Oracle数据库知识库

查看是否有表被锁住：select * from v$locked_object;

查看详细的信息：
select sess.sid,
sess.serial#,
lo.oracle_username,
lo.os_user_name,
ao.object_name,
lo.locked_mode
from v$locked_object lo, dba_objects ao, v$session sess, v$process p
where ao.object_id = lo.object_id
and lo.session_id = sess.sid;

结束掉锁住的表  alter system kill session ‘1327,42869’;

select 'alter system kill session '''||sess.sid||','||sess.serial#||''';'

from v$locked_object lo,

dba_objects ao,

v$session sess

where ao.object_id = lo.object_id and lo.session_id = sess.sid

orcle数据库数据导出

exp userName/Password@ip:1521/orcl file=/home/oracle/db.dmp owner=userName

orcle数据库数据导入

imp userName/Password file=/home/oracle/db.dmp  log=/home/oracle/db.log ignore=y full=y 

 

Mysql数据库知识库

1：查看当前的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;

杀死进程id，就是上面命令的trx_mysql_thread_id列
kill 线程ID;

2：查看当前锁定的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;

3：查看当前等锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;