How To Check Table Lock In Oracle?

306    Asked by DianaCampbell in SQL Server , Asked on Aug 4, 2023

We are utilizing BI software along with a repository database installed on Oracle Enetrprise 11gR2. Few batch reports will attempt at accessing a database table that’s locked. How do I check whether an oracle table is locked or not?

Answered by Danna sahi

You can try the elbow-mentioned command to check for oracle 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

The SQL Server Online Training offered at JanBask Training gives an experience like offline classes and prepares the students by covering the core concepts in MS SQL server certification making them ready to face the competitive job market. The students are also saved from the burden of traveling to physical locations to take classes. JanBaskTraining also aims to teach the wise methods of how the databases are generated and controlled in the business.



Your Answer

Interviews

Parent Categories