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

7 votes130 views1 answer
Oracle pagination query offset
SQL
0 vote159 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
1 vote174 views4 answers
Alter schema sql
SQL
1 vote102 views1 answer
Mysql get last insert id
SQL
0 vote155 views1 answer
How to get table id sequence postgres
SQL
0 vote123 views1 answer
Sql roll up rows into columns
SQL
244 votes224 views14 answers
Sql n insert
SQL
0 vote125 views1 answer
Oracle sql generate list of days
SQL
2 votes87 views5 answers
Alter table primary key postgresql
SQL
32 votes128 views6 answers
Sql count where
SQL