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 vote127 views1 answer
How refresh navicat tables to see new tables
SQL
-1 vote170 views1 answer
Sql show custom constraints
SQL
1 vote142 views1 answer
Age postgres
SQL
5 votes148 views1 answer
Oracle list packages
SQL
0 vote162 views1 answer
Postgres row expiration
SQL
0 vote156 views1 answer
Sqlite3 not commit
SQL
1 vote133 views1 answer
Oracle undo usage per session
SQL
0 vote130 views2 answers
Update information in a mysql column
SQL
0 vote128 views1 answer
Mysql use password error
SQL
1 vote139 views1 answer
Second last highest id in sql
SQL