Lock Status



Snapshot Level
Lock
Logical Data Grouping
lock
Monitor Switch
Basic


Resettable
No
 


Element Name
Element Type
lock_status
information

 

Description:  Indicates the internal status of the lock.

Usage:  This element can help explain what is happening when an application is waiting to obtain a lock on an object. While it may appear that the application already has a lock on the object it needs, it may have to wait to obtain a different type of lock on the same object.

The lock can be in one of the following statuses:

Granted state
indicates that the application has the lock in the state specified by Lock Mode.
Converting state
indicates that the application is trying to change the lock held to a different type; for example, changing from a share lock to an exclusive lock.
Note:API users should refer to the sqlmon.h header file containing definitions of database system monitor constants.