Oracle check table lock

select t2.username, t2.sid, t2.serial#, t3.object_name, t2.OSUSER, t2.MACHINE, t2.PROGRAM, t2.COMMAND, t2.LAST_CALL_ET
 from v$locked_object t1, v$session t2, dba_objects t3
 where t1.session_id = t2.sid and t1.object_id = t3.object_id
  ORDER BY t2.logon_time;

Similar codes

14 votes189 views4 answers
Import database through command line
SQL
-1 vote172 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
2 votes191 views1 answer
Pdo mysql insert
SQL
0 vote165 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
5 votes179 views2 answers
Oracle apex debug mode
SQL
0 vote190 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote184 views1 answer
Jenkins SQLCMD run
SQL
0 vote175 views1 answer
How to create an SQL save method in ruby
SQL
2 votes184 views3 answers
Sql server reseed identity column
SQL
0 vote191 views1 answer
Mysql sum per week
SQL