发布时间:2015-12-04 20:57:37
1、查看是否有锁表的sql select 'blocker('||lb.sid||':'||sb.username||')-sql:'|| qb.sql_text blockers, 'waiter ('||lw.sid||':'||sw.username||')-sql:'|| qw.sql_text waiters from v$lock lb, v$lock lw, v$session sb, v$session sw, v$sql qb, v$sql qw where lb.sid=sb.sid and lw.sid=sw.sid and .........【阅读全文】