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 vote183 views1 answer
Update from table tsql
SQL
10 votes186 views4 answers
Sql pagination
SQL
0 vote186 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
0 vote256 views1 answer
Alter database name script
SQL
0 vote181 views2 answers
Sqlite unix timestamp
SQL
0 vote181 views1 answer
Sql server remove enter from string
SQL
2 votes327 views1 answer
How to create sql database
SQL
8 votes175 views3 answers
Postgresql connection string c#
SQL
0 vote190 views1 answer
Mysql set variable to today's date
SQL
16 votes179 views1 answer
Sqlserver add column to table
SQL