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 vote280 views1 answer
Left join vs inner join performance
SQL
-1 vote272 views3 answers
SQL MM/dd/yyyy format
SQL
0 vote264 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
0 vote282 views1 answer
Postgresql replace html tags from string
SQL
0 vote261 views1 answer
Redudancy in SQL
SQL
0 vote261 views1 answer
T-sql check if data exists
SQL
1 vote268 views2 answers
Sql queries practice
SQL
0 vote272 views1 answer
How to reset the database value in SQL server
SQL
0 vote257 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
0 vote251 views2 answers
How to find max and min salary in sql
SQL