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 vote377 views1 answer
Sp help text in postgresql
SQL
0 vote286 views1 answer
How should I pass a table name into a stored proc?
SQL
0 vote300 views1 answer
Sql server select record with max id
SQL
7 votes320 views2 answers
Phpmyadmin change password
SQL
6 votes313 views2 answers
Difference between join vs union
SQL
1 vote285 views1 answer
Load sql into mamp
SQL
1 vote286 views1 answer
Postgresql last element of array
SQL
2 votes300 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
0 vote285 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
-1 vote311 views1 answer
Sql select data from one database and insert into a different database
SQL