查看和解锁的语句
select * from v$locked_object;
select * from v$session where sid in ((v$locked_object[SESSION_ID]));
alter system kill session '〔v$locked_object[SESSION_ID]〕,(v$session[SERIAL#])';
select * from v$bgprocess;
select * from dba_objects where object_id in (〔v$locked_object[SESSION_ID]〕);
-----------------------------
select * from v$session where sid in (select session_id from v$locked_object);
select distinct sql_id from v$session where sid in (select session_id from v$locked_object);
select ' '||sid||','||serial# from v$session where sid in (select session_id from v$locked_object)
锁说明:
ORACLE里锁有以下几种模式:
0:none
1:null 空
2:Row-S 行共享(RS):共享表锁,sub share
3:Row-X 行独占(RX):用于行的修改,sub exclusive
4:Share 共享锁(S):阻止其他DML操作,share
5:S/Row-X 共享行独占(SRX):阻止其他事务操作,share/sub exclusive
6:exclusive 独占(X):独立访问使用,exclusive
数字越大锁级别越高, 影响的操作越多。
select * from v$locked_object;
select * from v$session where sid in ((v$locked_object[SESSION_ID]));
alter system kill session '〔v$locked_object[SESSION_ID]〕,(v$session[SERIAL#])';
select * from v$bgprocess;
select * from dba_objects where object_id in (〔v$locked_object[SESSION_ID]〕);
-----------------------------
select * from v$session where sid in (select session_id from v$locked_object);
select distinct sql_id from v$session where sid in (select session_id from v$locked_object);
select ' '||sid||','||serial# from v$session where sid in (select session_id from v$locked_object)
锁说明:
ORACLE里锁有以下几种模式:
0:none
1:null 空
2:Row-S 行共享(RS):共享表锁,sub share
3:Row-X 行独占(RX):用于行的修改,sub exclusive
4:Share 共享锁(S):阻止其他DML操作,share
5:S/Row-X 共享行独占(SRX):阻止其他事务操作,share/sub exclusive
6:exclusive 独占(X):独立访问使用,exclusive
数字越大锁级别越高, 影响的操作越多。