How to view the list of locks on Oracle v9-11 database
This query will let you easily see the list of locks on database objects for Oracle v9 to 11. select c.owner, c.object_name, c.object_type, b.sid, b.serial#, b.status, b.osuser, b.machine from v$locked_object