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).