1
|
Alter
table
,
Drop
table
,
Drop
Index
,
Truncate
table
, Lock Exclusive
|
1
2
3
4
5
6
7
8
9
10
11
12
|
<CCID_NOBR>
<CCID_CODE>col owner
for
a12
col object_name
for
a16
select
b.owner,b.object_name,l.session_id,l.locked_mode
from
v$locked_object l, dba_objects b
where
b.object_id=l.object_id
/
select
t2.username,t2.sid,t2.serial#,t2.logon_time
from
v$locked_object t1,v$session t2
where
t1.session_id=t2.sid
order
by
t2.logon_time
/
|
<CCID_CODE>col owner for a12
col object_name for a16
select b.owner,b.object_name,l.session_id,l.locked_mode
from v$locked_object l, dba_objects b
where b.object_id=l.object_id
/
select t2.username,t2.sid,t2.serial#,t2.logon_time
from v$locked_object t1,v$session t2
where t1.session_id=t2.sid order by t2.logon_time
【ORA-02049】超时分布式事务处理等待锁 解决方法
(1)以sys用户登陆数据库查询死锁:
SQL> select username,lockwait,status,machine,program from v$session where sid in
(2)然后使用一下语句查找被死锁的语句
SQL> select sql_text from v$sql where hash_value in
(3)再使用以下语句查找被死锁的进程
SQL> SELECT s.username,l.OBJECT_ID,l.SESSION_ID,s.SERIAL#,
(4)使用一下语句把死锁的进程kill
SQL>alter system kill session ‘sid,serial#’; (其中sid=l.session_id)
如:SQL> alter system kill session '24,37522';