Find locks with Oracle

Most Oracle professionals use of the v$locked_object view in order to gather information about objects that are locked within the Oracle database.

Full article