Deadlocks         (Overview)

DESCRIPTION
The number of "Deadlocks" represents the total number of deadlocks encountered
since Sun MTP system initiation.  


VALUES
This value starts at zero and is incremented each time a deadlock occurs.


INTERPRETATION
A deadlock occurs when one application program (A), holding a particular 
resource X (e.g., a database record), requests another resource (Y) that is held
by another application program (B) that has concurrently requested the X 
resource held by program A. Each program is waiting on the other program to 
release a desired resource. This is sometimes referred to in the literature as a
'deadly embrace'. When this condition occurs, Sun MTP aborts the last application
program that requested a contended resource.


CONCLUSIONS
A large number of deadlocks may indicate that application programs require 
modification in the way they access the data within the database.  For example,
the sequence by which they acquire the data records may be the cause of the 
deadlock problem.
