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

1 vote218 views2 answers
Mysql current user
SQL
51 votes362 views6 answers
Opera gx
SQL
1 vote231 views1 answer
Postgresql create table with timestamp
SQL
-1 vote249 views1 answer
Brisanje dupliranih konatakata
SQL
3 votes246 views2 answers
Update Query in SQL Server
SQL
0 vote251 views1 answer
Psql check table fields
SQL
0 vote227 views1 answer
Mysql count with two joins
SQL
49 votes242 views6 answers
Mysql add column to table
SQL
4 votes217 views1 answer
Select nls_date_format
SQL
0 vote226 views1 answer
Qt qsql check if table exist
SQL