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 vote179 views2 answers
Script all indexes in a database
SQL
0 vote177 views1 answer
How to export table data from mysql table in sql format
SQL
0 vote197 views1 answer
Mysql begin statement
SQL
0 vote185 views1 answer
Oracle exchange subpartition
SQL
3 votes176 views2 answers
Update Query in SQL Server
SQL
0 vote180 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote210 views1 answer
Sql server beginning of month
SQL
-1 vote219 views3 answers
SQL MM/dd/yyyy format
SQL
0 vote172 views1 answer
How to count with except in psql
SQL
14 votes228 views3 answers
Inner join sql oracle
SQL