什么操作可以解锁
来源:互联网 发布:js判断浏览器兼容模式 编辑:程序博客网 时间:2024/04/28 23:09
解锁可以通过commit or rollback来解除。
如果你加的是EXCLUSIVE 锁,下一次是加不上了的
如果你加的是EXCLUSIVE 锁,下一次是加不上了的
1.查找系统中谁在锁表 (有很多种方法):
a).查找进程号和序列号
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;
FROM V$LOCKED_OBJECT T1, V$SESSION T2
WHERE T1.SESSION_ID = T2.SID
ORDER BY T2.LOGON_TIME;
b).查找进程号和序列号
set echo OFF rem 该脚本是用来检验系统中谁在锁表
column username format a13
column object_name format a10
column osuser format a10
column MACHINE format a10
column LockType format a10
select A.sid,b.serial#,
decode(A.type,'MR','Media Recovery','RT','Redo Thread',
'UN','User Name','TX','Transaction','TM','DML','UL','PL/SQL User Lock', 'DX','Distributed Xaction',
'CF','Control File','IS','Instance State','FS','File Set', 'IR', 'Instance Recovery', 'ST',
'Disk Space Transaction','TS','Temp Segment','IV','Library Cache Invalida-tion',
'LS','Log Start or Switch','RW','Row Wait','SQ', 'Sequence Number', 'TE',
'Extend Table','TT','Temp Table','Unknown')
column username format a13
column object_name format a10
column osuser format a10
column MACHINE format a10
column LockType format a10
select A.sid,b.serial#,
decode(A.type,'MR','Media Recovery','RT','Redo Thread',
'UN','User Name','TX','Transaction','TM','DML','UL','PL/SQL User Lock', 'DX','Distributed Xaction',
'CF','Control File','IS','Instance State','FS','File Set', 'IR', 'Instance Recovery', 'ST',
'Disk Space Transaction','TS','Temp Segment','IV','Library Cache Invalida-tion',
'LS','Log Start or Switch','RW','Row Wait','SQ', 'Sequence Number', 'TE',
'Extend Table','TT','Temp Table','Unknown')
LockType,c.object_name,
---b.username,
---b.osuser,
decode(a.lmode, 0,'None',1,'Null',2,'Row-S',3,'Row-X',
4,'Share',
5,'S/Row-X',
6,'Exclusive','Unknown')
---b.username,
---b.osuser,
decode(a.lmode, 0,'None',1,'Null',2,'Row-S',3,'Row-X',
4,'Share',
5,'S/Row-X',
6,'Exclusive','Unknown')
LockMode,
B.MACHINE,
D.SPID
from v$lock a, v$session b, all_objects c, V$PROCESS D
where a.sid = b.sid
and a.type in ('TM', 'TX')
and c.object_id = a.id1
and B.PADDR = D.ADDR
---order by username /
b).查找进程号和序列号
B.MACHINE,
D.SPID
from v$lock a, v$session b, all_objects c, V$PROCESS D
where a.sid = b.sid
and a.type in ('TM', 'TX')
and c.object_id = a.id1
and B.PADDR = D.ADDR
---order by username /
b).查找进程号和序列号
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;
FROM V$LOCKED_OBJECT T1, V$SESSION T2
WHERE T1.SESSION_ID = T2.SID
ORDER BY T2.LOGON_TIME;
c)。查找进程号和序列号(查询出所有被锁的会话):
SELECT sn.username, m.SID,sn.SERIAL#, m.TYPE,
DECODE (m.lmode,
0, 'None',
1, 'Null',
2, 'Row Share',
3, 'Row Excl.',
4, 'Share',
5, 'S/Row Excl.',
6, 'Exclusive',
lmode, LTRIM (TO_CHAR (lmode, '990'))
) lmode,
DECODE (m.request,
0, 'None',
1, 'Null',
2, 'Row Share',
3, 'Row Excl.',
4, 'Share',
5, 'S/Row Excl.',
6, 'Exclusive',
request, LTRIM (TO_CHAR (m.request, '990'))
) request,
m.id1, m.id2
FROM v$session sn, v$lock m
WHERE (sn.SID = m.SID AND m.request != 0) --存在锁请求,即被阻塞
OR ( sn.SID = m.SID --不存在锁请求,但是锁定的对象被其他会话请求锁定
AND m.request = 0
AND lmode != 4
AND (id1, id2) IN (
SELECT s.id1, s.id2
FROM v$lock s
WHERE request != 0 AND s.id1 = m.id1
AND s.id2 = m.id2)
)
ORDER BY id1, id2, m.request;
DECODE (m.lmode,
0, 'None',
1, 'Null',
2, 'Row Share',
3, 'Row Excl.',
4, 'Share',
5, 'S/Row Excl.',
6, 'Exclusive',
lmode, LTRIM (TO_CHAR (lmode, '990'))
) lmode,
DECODE (m.request,
0, 'None',
1, 'Null',
2, 'Row Share',
3, 'Row Excl.',
4, 'Share',
5, 'S/Row Excl.',
6, 'Exclusive',
request, LTRIM (TO_CHAR (m.request, '990'))
) request,
m.id1, m.id2
FROM v$session sn, v$lock m
WHERE (sn.SID = m.SID AND m.request != 0) --存在锁请求,即被阻塞
OR ( sn.SID = m.SID --不存在锁请求,但是锁定的对象被其他会话请求锁定
AND m.request = 0
AND lmode != 4
AND (id1, id2) IN (
SELECT s.id1, s.id2
FROM v$lock s
WHERE request != 0 AND s.id1 = m.id1
AND s.id2 = m.id2)
)
ORDER BY id1, id2, m.request;
2.杀进程(解锁):
通过以上查询知道了sid和 SERIAL#(即:进程号,序列号)就可以开杀了
ALTER SYSTEM KILL SESSION ‘SID,SERIR#’;
ALTER SYSTEM KILL SESSION ‘SID,SERIR#’;
- 什么操作可以解锁
- 什么叫解锁 Bootloader
- 有时候由于操作原因,碰到锁表情况,接下来可以根据这两步进行解锁
- SVN强制解锁操作
- PHP加锁解锁操作
- SVN解锁操作
- SVN强制解锁操作
- Hive 解锁操作
- Oracle 解锁操作
- Linux 用户操作-解锁
- Oracle解锁表操作
- Tuit:可以解锁手机的NFC戒指
- 系统中表被锁后,可以这样解锁。
- 我们可以期待什么?
- Spacebuilder可以做什么?
- 有什么可以传承
- 没有什么可以阻挡
- GIS可以做什么?
- 存储过程中如何将日期转换成字符型(重点)
- Creating a .NET Web Service
- 使用ASP.NET Web服务代理的URL行为属性
- asp.net 2.0 中DataFormatString不起作用的解决方案
- ApplicationContext事件传播实际应用
- 什么操作可以解锁
- KGDB Quick Start
- DataFormatString格式字符串
- ASP.NET2.0雷霆之怒盗链者的祝福
- Web SSO 的样例下载、安装部署和运行指南:
- Java Servlet的基本特征、开发环境的配置以及Servlet的一些主要API类
- Linux 设备驱动 Edition 3
- 设计模式主要几种
- 视图简介