How to determine if an Oracle table is locked or not?

48 votes

7 answers

838279 views

oracle-11g-r2 locking business-intelligence

                          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?

Asked by Selahattin (621 rep)

Jan 12, 2014, 01:22 PM
Last activity: Jan 2, 2021, 04:58 PM

How to determine if an Oracle table is locked or not?

Related Questions