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 vote113 views1 answer
Oracle table free space
SQL
8 votes125 views1 answer
Oracle add datafile to tablespace
SQL
21 votes94 views7 answers
Table drop if exist sql server
SQL
0 vote114 views1 answer
Postgresql get current user name
SQL
8 votes126 views1 answer
Unique vs primary key
SQL
1 vote84 views1 answer
Metada in sql
SQL
0 vote140 views1 answer
Sqlite woth cmake
SQL
1 vote153 views1 answer
Mysql previous year
SQL
-2 votes116 views1 answer
Modify column name in tsql
SQL
0 vote131 views1 answer
Learnxinyminutes sql
SQL