展会信息港展会大全

ORACLE查锁语句 android开发教程
来源:互联网   发布日期:2016-01-28 13:03:26   浏览:2037次  

导读:SELECT substr(v$lock.sid,1,4) SID, substr(username,1,12) UserName, substr(object_name,1,25) ObjectName, v$lock.type LockType, decode(rtrim(substr(lmode,1,4)), '2','Row-S (SS)','3','Row-X (SX)', '4','Share', '5','S/Row-X (SSX)', '6','Exclus...

SELECT substr(v$lock.sid,1,4) "SID",

substr(username,1,12) "UserName",

substr(object_name,1,25) "ObjectName",

v$lock.type "LockType",

decode(rtrim(substr(lmode,1,4)),

'2','Row-S (SS)','3','Row-X (SX)',

'4','Share', '5','S/Row-X (SSX)',

'6','Exclusive', 'Other' ) "LockMode",

substr(v$session.program,1,25) "ProgramName"

FROM V$LOCK,SYS.DBA_OBJECTS,V$SESSION

WHERE (OBJECT_ID = v$lock.id1

AND v$lock.sid = v$session.sid

AND username IS NOT NULL

AND username NOT IN ('SYS','SYSTEM')

AND SERIAL# != 1);

select a.sid, a.SERIAL#, b.spid, a.status, a.PROGRAM

from v$session a, V$PROCESS b

where a.paddr=b.ADDR

order by a.sid;

alter system kill session '200,68' immediate;

赞助本站

人工智能实验室
AiLab云推荐
展开

热门栏目HotCates

Copyright © 2010-2024 AiLab Team. 人工智能实验室 版权所有    关于我们 | 联系我们 | 广告服务 | 公司动态 | 免责声明 | 隐私条款 | 工作机会 | 展会港