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 vote366 views1 answer
Psql search table
SQL
0 vote367 views1 answer
Mysql c commands
SQL
0 vote398 views1 answer
Get primary key of table
SQL
5 votes334 views3 answers
Truncate function in sql oracle
SQL
0 vote355 views1 answer
Mysqldump ignore table
SQL
1 vote410 views1 answer
Encrypt password postgresql
SQL
1 vote353 views2 answers
Oracle list partitioned tables
SQL
0 vote352 views1 answer
Mysql jdbc timezone
SQL
0 vote367 views2 answers
Collation in sql
SQL
0 vote358 views2 answers
Postgresql display subquery as json
SQL