Oracle Lock Information Queries
--Find out what objects are locked.
select
c.owner,
c.object_name,
c.object_type,
b.sid,
b.serial#,
b.status,
b.osuser,
b.machine
from
v$locked_object a ,
v$session b,
dba_objects c
where
b.sid = a.session_id
and
a.object_id = c.object_id;
--Find out all blocking locks
select * from v$lock where block > 0;
--Find out blocker and blockee
select
(select username || ' - ' || osuser from v$session where sid=a.sid) blocker,
a.sid || ', ' ||
(select serial# from v$session where sid=a.sid) sid_serial,
' is blocking ',
(select username || ' - ' || osuser from v$session where sid=b.sid) blockee,
b.sid || ', ' ||
(select serial# from v$session where sid=b.sid) sid_serial
from v$lock a, v$lock b
where a.block = 1
and b.request > 0
and a.id1 = b.id1
and a.id2 = b.id2;
select
c.owner,
c.object_name,
c.object_type,
b.sid,
b.serial#,
b.status,
b.osuser,
b.machine
from
v$locked_object a ,
v$session b,
dba_objects c
where
b.sid = a.session_id
and
a.object_id = c.object_id;
--Find out all blocking locks
select * from v$lock where block > 0;
--Find out blocker and blockee
select
(select username || ' - ' || osuser from v$session where sid=a.sid) blocker,
a.sid || ', ' ||
(select serial# from v$session where sid=a.sid) sid_serial,
' is blocking ',
(select username || ' - ' || osuser from v$session where sid=b.sid) blockee,
b.sid || ', ' ||
(select serial# from v$session where sid=b.sid) sid_serial
from v$lock a, v$lock b
where a.block = 1
and b.request > 0
and a.id1 = b.id1
and a.id2 = b.id2;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/638844/viewspace-776963/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle lock鎖_v$lock_轉Oracle
- [Oracle Script] LockOracle
- About Oracle LockOracle
- oracle enqueue lockOracleENQ
- Oracle Latch & LockOracle
- ORACLE LOCK,LATCH,PINOracle
- ORACLE LOCK MODE 1.2.3.4.5.6Oracle
- Dead lock - oracleOracle
- ORACLE lock 轉貼Oracle
- ORACLE查LOCK表Oracle
- oracle lock系列一Oracle
- PG: Utility queries
- CSS media queriesCSS
- oracle v$lock詳解Oracle
- [Oracle Script] check lock infoOracle
- Oracle 之pin和lockOracle
- Oracle Lock Management Services (365)Oracle
- oracle dead lock與效能Oracle
- oracle使用者被lockOracle
- oracle v$lock系列之三Oracle
- Uncertainy and informationAIORM
- ORACLE基礎之oracle鎖(oracle lock mode)詳解Oracle
- Information Center: Oracle Scalability GI/Clusterware and RAC_1452965.2ORMOracle
- oracle異常:library cache lockOracle
- Oracle如何查詢當前LockOracle
- oracle DBMS_LOCK.SLEEP()的使用Oracle
- Oracle裡面的user被lock了Oracle
- INFORMATION CENTER: Oracle Automatic Storage Management_1472204.2ORMOracle
- Oracle blocking issue with lock table in exclusive modeOracleBloC
- oracle breakable parse lock 易碎解析鎖Oracle
- oracle deadlock with TM lock in SX/SSX modeOracle
- Oracle中latch和lock的區別Oracle
- [ORACLE 11G]ROW CACHE LOCK 等待Oracle
- Oracle:ORA-01219:database not open:queries allowed on fixed tables/views onlyOracleDatabaseView
- Certification Information for Oracle Database on Linux x86-64 [ID 1304727.1]ORMOracleDatabaseLinux
- [Information Security] What is WEPORM
- Oracle RAC Cache Fusion 系列十:Oracle RAC Enqueues And Lock Part 1OracleENQ
- oracle lock轉換及oracle deadlock死鎖系列一Oracle