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 vote320 views1 answer
Mariadb number format
SQL
-1 vote320 views1 answer
MYSQL stored procedure select from
SQL
0 vote346 views1 answer
Timestamp(0) postgresql
SQL
0 vote329 views1 answer
How to alter length character varying postgres
SQL
0 vote329 views1 answer
How to change null display in psql
SQL
0 vote352 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote281 views1 answer
Sqlalchemy filter relationship
SQL
0 vote320 views1 answer
Postgresql select fast check no rows
SQL
0 vote345 views1 answer
Mysql remove last character
SQL
1 vote343 views1 answer
Sql server insert into temp table
SQL