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

4 votes350 views3 answers
Drop Table Oracle
SQL
15 votes360 views2 answers
Select where duplicate mysql
SQL
3 votes349 views3 answers
How to add month in update sql
SQL
0 vote323 views1 answer
Insert or update cassandra
SQL
0 vote342 views1 answer
Mysql wsrep ls
SQL
23 votes363 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote342 views2 answers
Check mysql timezone
SQL
2 votes347 views6 answers
In operator in sql
SQL
1 vote348 views1 answer
Postgres convert date to string
SQL
-1 vote338 views1 answer
Adding a new table psql
SQL