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 vote147 views1 answer
Xamarin sql lite create table if not exist
SQL
0 vote142 views1 answer
Postgres get running query
SQL
0 vote146 views1 answer
Rails sql query converstion
SQL
0 vote122 views1 answer
Sql remove last x char
SQL
17 votes146 views6 answers
MySQL ORDER BY
SQL
0 vote125 views1 answer
Print orcale
SQL
0 vote126 views4 answers
Best data type to represent money in mysql
SQL
0 vote139 views1 answer
Mysql coonect sample code
SQL
0 vote151 views1 answer
Add a new column into table
SQL
2 votes145 views1 answer
Query to find table size in oracle 12c
SQL