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

1 vote274 views1 answer
Show per page table in xampp
SQL
7 votes303 views1 answer
Mysql remote connection command line
SQL
1 vote261 views1 answer
Oracle user last connected
SQL
0 vote268 views1 answer
Min and max salary and name in sql
SQL
0 vote327 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote276 views1 answer
Postgresql not in alternative
SQL
0 vote279 views1 answer
MySQL import data from large CSV file
SQL
0 vote292 views1 answer
Lost connection to mysql
SQL
4 votes291 views1 answer
Search column by name mysql
SQL
0 vote272 views1 answer
How to define a save method in ruby for sql databases
SQL