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 vote304 views1 answer
Mssql find deadlocks
SQL
0 vote261 views2 answers
Postgres default user
SQL
8 votes275 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
1 vote253 views3 answers
Sql server get week dates from week number
SQL
27 votes313 views3 answers
Mysql delete row
SQL
1 vote249 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote263 views1 answer
Execut sql python
SQL
11 votes271 views6 answers
Distinct sql
SQL
0 vote250 views1 answer
Postgresql default value boolean
SQL
0 vote245 views1 answer
Joins vs includes
SQL