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

31 votes338 views4 answers
How to get duplicate records with multiple field in sql
SQL
15 votes610 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote281 views2 answers
Jupyter notebook connect to database
SQL
1 vote303 views1 answer
Unique vs distinct sql
SQL
8 votes342 views2 answers
Python simple connect to mysql
SQL
49 votes384 views6 answers
Get duplicate records in sql
SQL
0 vote346 views1 answer
Sql query to return field name of a table
SQL
0 vote324 views1 answer
SQL isnumeric DB2
SQL
0 vote341 views1 answer
Mysql timediff
SQL
1 vote365 views1 answer
Connect to mysql database ubuntu
SQL