onLockTable

The following list summarizes this table:

Contents:: Information about the active locks that database servers are using
Index:: applIndex, onSessionIndex, onLockIndex
Scope of a row:: One lock
A row exists for each lock that the session is using and for each lock on which the session is waiting.

The table has the following MIB objects.

Table 1. MIB objects for onLockTable
MIB object	Description
applIndex	See applTable.
onSessionIndex	See onServerTable.
onLockIndex	Index to this row
onLockDatabaseName	Name of the database that is using or waiting for this lock
onLockTableName	Name of the table that is using or waiting for this lock
onLockType	Type of the lock: byte (1) intentShared (2) shared (3) sharedByRepeatableRead (4) update (5) intentExclusive (6) sharedIntentExclusive (7) exclusive (8) exclusiveByRepeatableRead (9) waiting (10)
onLockGranularity	Granularity of the lock: table (1) page (2) row (3) index (4)
onLockRowId	rowid of the locked row
onLockWaiters	Number of sessions that are waiting for the lock
onLockGrantTime	Time when the lock was granted if the session is using the lock If no transaction exists, this value is noSuchInstance (SNMPv2) or noSuchName (SNMPv1).