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 vote416 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote334 views2 answers
Mysql slave status
SQL
5 votes377 views1 answer
Add column table sql default value
SQL
0 vote331 views1 answer
Create domain sql
SQL
0 vote416 views1 answer
Reindexing all tables sql server
SQL
7 votes341 views3 answers
Postgre describe table
SQL
0 vote364 views1 answer
Close sql query vb.net
SQL
0 vote340 views2 answers
T SQl Checking Your Username
SQL
0 vote365 views1 answer
How to query without duplicate rows in sql
SQL
0 vote337 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL