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 vote343 views1 answer
Show specific events on mysql
SQL
8 votes323 views1 answer
Script to add datafile to tablespace
SQL
4 votes332 views2 answers
Truncate oracle
SQL
0 vote306 views1 answer
Postgres call view
SQL
4 votes294 views1 answer
Oracle show error line number
SQL
1 vote300 views1 answer
Sql group by error
SQL
2 votes333 views2 answers
Mysql add hours to time field
SQL
1 vote302 views1 answer
Oracle sql create or replace view
SQL
0 vote337 views1 answer
Sql today at midnight
SQL
2 votes310 views1 answer
Apex execute batch job
SQL