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 vote172 views1 answer
Postgres row expiration
SQL
0 vote140 views1 answer
Mysql where in keep order
SQL
0 vote137 views1 answer
Datetime postgres typeorm
SQL
1 vote143 views1 answer
Hackerrank sql test solutions
SQL
0 vote156 views1 answer
Play framework connection via windows sql server
SQL
0 vote144 views1 answer
Mysql select all where count more than"
SQL
0 vote154 views1 answer
Count in sql and diff
SQL
0 vote135 views2 answers
Oracle create chain rule
SQL
3 votes130 views1 answer
Oracle user quota unlimited
SQL
37 votes331 views3 answers
Sql check duplicate value in column
SQL