How to Use Forms to Display the User Who Locks a Table Row (Doc ID 789978.1)

Last updated on FEBRUARY 23, 2017

Applies to:

Oracle Forms - Version: 6.0.8 and later   [Release: 6.0.8 and later ]
Information in this document applies to any platform.
***Checked for relevance on 03-Nov-2010***
***Checked for relevance on 04-Apr-2012***

Goal

How to find the USER who has a lock on a table's row. 

The Form created here can also be used to find additional information about DB locks such as:

1.   Locks on specific tables.

2.  All table locks in the DB.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms