How to check table lock in oracle?

2.8K    Asked by EmmaCornish in SQL Server , Asked on Oct 3, 2022

We've been using BI software and a repository database that are installed on Oracle Enterprise 11gR2.

Some of these batch reports will try to access a database table which may still be locked. How can I find out if an Oracle table is locked or not? Is there any SQL statement that displays like history details to analysis?

Answered by Emma Lewis

The answer to your question - how to check table lock in oracle is -

Following query gives details of all locks.

SELECT B.Owner, B.Object_Name, A.Oracle_Username, A.OS_User_Name  
FROM V$Locked_Object A, All_Objects B
WHERE A.Object_ID = B.Object_ID

Your Answer


Parent Categories