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 vote186 views1 answer
Check if record exists mysql
SQL
1 vote253 views1 answer
Postgresql pass array in function
SQL
3 votes257 views2 answers
Oracle privileges users
SQL
0 vote212 views1 answer
Sql max of two values
SQL
-1 vote188 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
5 votes189 views1 answer
Oracle ORA-00054 origin
SQL
2 votes227 views5 answers
Tablespace ORACLE
SQL
3 votes208 views2 answers
Having in mysql
SQL
0 vote205 views1 answer
Postgres reorder columns
SQL
3 votes203 views1 answer
Oracle revoke
SQL