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

0 vote154 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
0 vote116 views1 answer
Oracle sysdba connect as another user
SQL
3 votes146 views1 answer
Delete all content in table mysql
SQL
4 votes139 views2 answers
Dbms_scheduler stop job
SQL
0 vote149 views1 answer
Mysql workbench procedure
SQL
0 vote152 views1 answer
Pass array parameter to stored procedure c#
SQL
0 vote146 views1 answer
Which lock mode is not available in sql
SQL
2 votes196 views2 answers
Create table mysql integer NOT null
SQL
9 votes134 views2 answers
Default number in sql
SQL
11 votes168 views2 answers
Mysql disable safe mode
SQL