Mode=(mode-list)

    Indicates the lock mode to be displayed. If you specify more than
    one option in the mode-list, you must separate the options with
    a comma, and enclose the mode-list in parentheses. The following
    lock mode options are available:

    o  Blocking

       Displays the set of processes whose locks are blocking the
       lock requests of other processes. A process is considered
       to be waiting when it has requested a lock mode that is
       incompatible with existing granted lock modes; in this case,
       the requestor is the waiting process and the grantors are the
       blocking processes.

       The first line of output identifies a process that is waiting
       for a lock request to be granted. All subsequent lines of
       output identify those processes that are preventing the
       lock request from being granted. When multiple processes
       are waiting for the same lock resource, multiple sets of
       process-specific information, one for each waiting process,
       are displayed.

    o  Culprit

       Displays the set of locks for processes that are blocking
       other processes but are themselves not locked. The output
       represents the processes that are the source of database
       stalls and performance degradation.

    o  Waiting

       Displays the set of processes whose lock requests are waiting
       due to incompatible granted locks for other processes. A
       process is considered to be blocking others when it has been
       granted a lock mode that is incompatible with requested lock
       modes; in this case, the "Blocker" is the blocking process and
       the "Waiting" are the waiting processes.

       A requesting process can appear to be waiting for other
       lock requestors. This condition occurs when there are many
       processes waiting on the same lock resource. Depending upon
       the sequence of processes in the wait queue, certain waiting
       processes appear to be blocking other waiting processes
       because, eventually, they will be granted the lock first.

       The first line of output identifies a process that has been
       granted a lock on a resource. All subsequent lines of output
       identify those processes that are waiting for lock requests on
       the same resource to be granted. When multiple processes are
       blocking the same lock resource, multiple sets of process-
       specific information, one for each blocking process, are
       displayed.