RMUDISPLAY72.HLB  —  Overview  Screens  Process Lock Overview screen
    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.
Close Help