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 vote169 views1 answer
Mysql count multiple columns in one query
SQL
6 votes170 views1 answer
SQL insert all columns
SQL
1 vote194 views1 answer
Connect to mysql database ubuntu
SQL
3 votes170 views1 answer
Force using index oracle
SQL
2 votes176 views1 answer
Oracle to_char number format percentage
SQL
0 vote176 views1 answer
Example of sql querry result sepapreted by comma
SQL
-1 vote184 views1 answer
Can pandas fetch data from sql
SQL
2 votes170 views2 answers
Compare date mysql
SQL
0 vote180 views1 answer
Mssql dockere
SQL
1 vote175 views1 answer
Mysql pretty date format
SQL