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

12 votes208 views3 answers
Install sqlite driver ubuntu
SQL
1 vote193 views2 answers
Mysql type conversion
SQL
0 vote202 views4 answers
Forenkey code alchemy sql
SQL
0 vote209 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
10 votes192 views4 answers
Primary key sql
SQL
1 vote256 views1 answer
Best configuration for display table in sqlplus
SQL
0 vote191 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote223 views1 answer
Sql tabelle erstellen
SQL
0 vote191 views1 answer
Sql query for select from specific columns in a table
SQL
0 vote210 views1 answer
Sql query to force the database to be drop
SQL