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 vote274 views1 answer
Sql select all tables from database change url
SQL
0 vote285 views1 answer
Narural join
SQL
0 vote291 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
1 vote284 views1 answer
Adding a check statement in sql
SQL
0 vote277 views1 answer
TSQL function split string
SQL
0 vote283 views1 answer
Mysql pad zeros
SQL
0 vote251 views1 answer
Big query add table rows to another table
SQL
0 vote287 views1 answer
Exec procedure oracle
SQL
0 vote250 views1 answer
Deleted table in sql trigger
SQL
36 votes353 views6 answers
Change column data type sql
SQL