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

3 votes292 views1 answer
Mysql insert on dupèlicate
SQL
2 votes273 views1 answer
How to show the whole table in sql
SQL
0 vote274 views1 answer
Pass array parameter to stored procedure c#
SQL
0 vote299 views1 answer
Hibernate dialect property xml for mysql 8
SQL
1 vote289 views1 answer
Sql string function update replace
SQL
1 vote269 views2 answers
Sql left characters
SQL
0 vote344 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote292 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
2 votes267 views1 answer
Sql skip the first row
SQL
6 votes292 views2 answers
Mysqldump password in file
SQL