onLockTable

The following list summarizes this table:

Contents:

Information about the active locks that database servers and coservers 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.

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