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 vote105 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote109 views2 answers
How to update the multiple rows in sql
SQL
9 votes122 views3 answers
Where clause sql
SQL
9 votes102 views2 answers
Sql server check table exists
SQL
20 votes117 views6 answers
Mysql reset auto increment
SQL
-1 vote117 views3 answers
PS5
SQL
1 vote62 views1 answer
Psql kill pid
SQL
2 votes99 views1 answer
Sql server find table name
SQL
1 vote102 views1 answer
What is intersect
SQL
0 vote111 views1 answer
Drop all procedures sql server
SQL