The RECORD_LOCK_INFO view returns one row for every record lock for the partition.
The values returned for the columns in the view are closely related to the values returned by Retrieve Record Locks API. Refer to the APIs for more detailed information.
When querying this view, you should use a WHERE clause to restrict the result set to avoid excessive use of system resources.
Was this topic helpful?
19 December 2019