| 标题 | ORACLE查锁语句 |
| 内容 | 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; |
| 随便看 |
|
在线学习网考试资料包含高考、自考、专升本考试、人事考试、公务员考试、大学生村官考试、特岗教师招聘考试、事业单位招聘考试、企业人才招聘、银行招聘、教师招聘、农村信用社招聘、各类资格证书考试等各类考试资料。