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 vote250 views1 answer
How to find lowest in sql
SQL
0 vote235 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
6 votes223 views3 answers
Mysql server is not starting xampp
SQL
0 vote241 views1 answer
Postgres create extension if not exists
SQL
3 votes232 views2 answers
Oracle synonym
SQL
0 vote235 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
2 votes251 views1 answer
Oracle generated column
SQL
0 vote228 views1 answer
Mysql shell set time_zone
SQL
0 vote226 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
0 vote224 views1 answer
Dns slave zone convert
SQL