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 vote193 views1 answer
Pgadmin see indexes
SQL
0 vote249 views1 answer
Mysql, how to query the table comments?
SQL
0 vote224 views1 answer
Get substract count sql
SQL
0 vote198 views1 answer
Get first 3 letter of department name in sql
SQL
-1 vote226 views2 answers
Sql truncate number
SQL
0 vote167 views1 answer
Mysql date + 1 day
SQL
0 vote180 views1 answer
Delete data from database sqlite android
SQL
0 vote199 views1 answer
Neo4j command to run script file
SQL
0 vote191 views1 answer
Sql select first and last record of each group
SQL
1 vote197 views1 answer
Mysql select if empty result
SQL