This screen provides summary locking information for all
processes activated to collect global statistics using the
Process Monitoring facility.
The processes displayed on this screen have previously activated
their global statistics collection. Process global statistic
collection can be either implicitly activated by the database
monitor, or explicitly activated by the RMU Show Statistic
utility.
This screen provides the following information:
o Process.ID
The process ID for the current process, assigned by the
operating system, and the stream ID, assigned by the database.
If "G" is appended to the process ID, the process had been
activated for global statistics collection; this is the normal
case. Server processes will be designated with the "s" tag.
o Lock.Rqsts
This field gives the number of lock requests, also referred
to as "enqueue" lock requests, for new locks. Whether the lock
request succeeds or fails, it is included in this count. The
"rqsts not queued", "rqsts stalled", and "rqst deadlocks"
counts provide further detail for enqueue lock requests
statistics.
o prom.Rqsts
This field gives the number of enqueue lock requests to
promote an existing lock to a higher lock mode. Whether
or not the lock request succeeds, it is included in this
count. The "proms not queued," "proms stalled," and "prom
deadlocks" counts provide further detail for the locks
promotion statistics.
o Deadlocks
This field gives the number of stalled enqueue lock requests
to promote an existing lock that ultimately resulted in a
deadlock. Most deadlocks are tried again and resolved
o Blasted
This field gives the number of blocking ASTs, sometimes
referred to as "blasts", delivered to Oracle Rdb by the lock
manager. A blocking AST is delivered to the holder of a lock
when a lock conflict is detected, which is a good indication
of contention problems. When Oracle Rdb receives a blocking
AST, it often demotes or releases a lock in an attempt to
avoid unnecessary deadlocks.
The number of blocking ASTs reported is composed of two
different types of blocking ASTs: those generated externally
and those generated internally.
An externally generated blocking AST occurs when a blocking
AST is actually received by the process from the operating
system in response to some lock conflict with another process.
A blocking AST routine is executed and the RMU Show Statistic
utility records the blocking AST activity.
An internally generated blocking AST occurs when a lock-
blocking AST routine is executed by the process in
anticipation that the same work would have to be performed
anyway if a blocking AST were to be received from the
operating system. This algorithm serves as an optimistic
code optimization; the process, assuming it would eventually
receive a blocking AST for the particular lock, executes the
blocking AST routine. The RMU Show Statistic utility does not
differentiate between these two types of blocking ASTs.
o Demotes
This field gives the number of enqueue lock requests to demote
an existing lock to a lower lock mode. These requests always
succeed.
o Unlocks
This field gives the number of deallocating lock requests to
release an existing lock. These requests always succeed.