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

3 votes186 views3 answers
Create table in microsoft sql server
SQL
0 vote169 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
0 vote169 views1 answer
Watch mysql command line
SQL
0 vote214 views1 answer
Oracle running queries
SQL
0 vote280 views1 answer
Sql server query all database objects
SQL
0 vote160 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote166 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote207 views1 answer
Ceil upto 2 decimal place mysql
SQL
8 votes199 views3 answers
Find table for column name in sql
SQL
0 vote221 views1 answer
How to compile a function in oracle
SQL