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

0 vote165 views1 answer
Find wordpress version in database
SQL
0 vote133 views1 answer
Sql server remove enter from string
SQL
13 votes129 views5 answers
Oracle list tables
SQL
0 vote151 views1 answer
Sql field equals multiple values
SQL
2 votes185 views1 answer
Db.relationship sqlalchemy flask
SQL
2 votes183 views2 answers
Mysql date range
SQL
1 vote190 views1 answer
Oracle transaction rollback not working
SQL
0 vote126 views1 answer
Oracle sql log to console
SQL
0 vote133 views1 answer
Drop a field in psql django
SQL
24 votes132 views5 answers
Sql reset auto increment
SQL