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

4 votes156 views1 answer
Mysql ip address data type
SQL
0 vote146 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
18 votes146 views6 answers
Mysql create table
SQL
2 votes154 views3 answers
Mysql list tables by size
SQL
1 vote154 views2 answers
Oracle create synonym
SQL
0 vote138 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
4 votes185 views1 answer
How to check last gather stats on table in oracle
SQL
5 votes151 views3 answers
Truncate function in sql oracle
SQL
0 vote134 views1 answer
Dump multiple tables mysql
SQL
0 vote146 views1 answer
Start and stop mysql
SQL