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 vote317 views1 answer
How to show current database in mysql
SQL
0 vote220 views1 answer
How to combine first and last nae into one columb sql
SQL
2 votes197 views1 answer
Get first 3 letters name in sql
SQL
44 votes278 views6 answers
Rename command in sql
SQL
3 votes208 views1 answer
How to check schema privileges in oracle
SQL
0 vote211 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote171 views1 answer
Query for maximum salary
SQL
0 vote196 views1 answer
Java input type sql date
SQL
1 vote228 views2 answers
Oracle 18c xe ORA-65096
SQL
0 vote208 views1 answer
Mysqldump don't drop table
SQL