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 vote190 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
0 vote214 views1 answer
Many rows to 1 string mysql
SQL
0 vote218 views1 answer
Postgresql not in alternative
SQL
1 vote210 views1 answer
Postgresql filter on
SQL
6 votes240 views1 answer
How to get the size of the database in postgresql
SQL
4 votes222 views1 answer
Alter session set nls_date_format
SQL
0 vote219 views1 answer
Contact mysql column field
SQL
0 vote207 views1 answer
Difference between cross apply and inner join
SQL
19 votes231 views5 answers
Date between in mysql
SQL
2 votes231 views1 answer
Alter table add column and foreign key mysql
SQL