My Oracle Support Banner

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

Last updated on OCTOBER 28, 2019

Applies to:

Oracle Forms - Version 6.0.8 to 11.1.2.0.0 [Release 6.0.8 to 11g]
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

To view full details, 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 a vibrant support community of peers and Oracle experts.