1 – Lock
Lock=lock-list
Displays information for each of the specified locks. When
combined with the Mode=Blocking qualifier, the Lock qualifier
displays information about processes whose locks are blocking the
specified locks. When combined with the Mode=Waiting qualifier,
the Lock qualifier displays information about processes whose
lock requests are waiting for the specified locks.
One or more locks can be specified; if more than one lock is
specified, they must be enclosed in parentheses and separated
by commas. The lock identifier is an 8-digit hexadecimal number,
and must be local to the node on which the RMU Show Locks command
is issued. To see the lock identifier upon which a process is
waiting, you can do either of the following:
o Invoke the character cell Performance Monitor "Stall Messages"
display.
o Invoke the Performance Monitor from your PC and select
Displays
2 – Mode
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.
3 – Options
Options=(option-list)
Indicates the type of information and the level of detail the
output will include. If you do not specify the Options qualifier,
the default output is displayed. If you specify more than one
type of output for the Options qualifier, you must separate
the options with a comma, and enclose the options list within
parentheses. The following options are available:
o All
Used when you want the complete list of process locks; by
default, lock information for only the specified process is
displayed. When you specify the All option, information is
displayed for all other processes that have a need to know
the lock held by the specific process. This method is an easy
way to display all of a process' locks and to see what other
processes are also using the same resource.
If the Mode qualifier is specified, the Options=(All)
qualifier is ignored.
o Full
Indicates that special database processes are to be displayed.
Some special database processes, such as monitors, perform
work on behalf of a database. These database processes
frequently request locks that by design conflict with other
processes' locks; the granting of these locks indicates an
important database event.
By default, these special database processes are not displayed
because they increase the size of the output.
4 – Output
Output[=file-name]
Specifies the name of the file where output is sent. The default
is SYS$OUTPUT. The default output file extension is .lis, if you
specify only a file name.
5 – Process
Process=process-list
Displays information for each lock held or requested by the
specified processes when used by itself. When the Process
qualifier is combined with the Mode=Blocking qualifier,
information is displayed about processes whose locks are blocking
lock requests by the specified waiting processes.
NOTE
When the Process qualifier is specified without any Options
qualifier values, all locks for the processes are displayed,
including owning, blocking, and waiting locks.
One or more processes can be specified; if more than one process
is specified, they must be enclosed within parentheses and
separated by commas. The process identifier is an 8-digit
hexadecimal number, and must be local to the node on which the
RMU Show Locks command is issued. The process ID must include all
eight characters; the node identifier portion of the process ID
cannot be excluded. To get more information, use the Options=All
qualifier to display all users using processes' locks.
6 – Resource type
Resource_type=resource-type-list
Displays information for each lock held or requested by the
specified resource type. Only the specific resource types will
be displayed. This permits, for example, only PAGE or RECORD lock
types to be selected.
One or more resouce types can be specified; if more than one
type is specified, they must be enclosed within parentheses and
separated by commas.
The following keywords are allowed with the Resource_type
qualifier.
Table 17 RESOURCE_TYPE Keywords
Internal
Lock Type
Name Keyword(s)
ACCESS ACCESS
ACTIVE ACTIVE
AIJDB AIJDB
AIJFB AIJFB
AIJHWM AIJHWM, AIJ_HIGH_WATER_MARK
AIJLOGMSG AIJ_LOG_MESSAGE
AIJLOGSHIP AIJ_LOG_SHIPPING
AIJOPEN AIJ_OPEN
AIJSWITCH AIJ_SWITCH
AIJ AIJ
AIPQHD AIP
ALS ALS_ACTIVATION
BCKAIJ AIJ_BACKUP, BCKAIJ
BCKAIJ_SPD AIJ_BACKUP_SUSPEND
BUGCHK BUGCHECK
CHAN CHAN, FILE_CHANNEL
CLIENT CLIENT
CLOSE CLOSE
CLTSEQ CLTSEQ
CPT CORRUPT_PAGE_TABLE, CPT
DASHBOARD DASHBOARD_NOTIFY
DBK_SCOPE DBKEY_SCOPE
DBR DBR_SERIALIZATION
DB DATABASE
FIB FAST_INCREMENTAL_BACKUP, FIB
FILID FILID
FRZ FREEZE
GBL_CKPT GLOBAL_CHECKPOINT
GBPT_SLOT GLOBAL_BPT_SLOT
KROOT KROOT
LAREA LAREA, LOGICAL_AREA
LOGFIL LOGFIL
MEMBIT MEMBIT
MONID MONID, MONITOR_ID
MONITOR MONITOR
NOWAIT NOWAIT
PLN DBKEY, RECORD, PLN
PNO PAGE, PNO
QUIET QUIET
RCACHE RCACHE
RCSREQUEST RCS_REQUEST
RCSWAITRQST RCS_WAIT_REQUEST
REL_AREAS RELEASE_AREAS
REL_GRIC_ RELEASE_GRIC_REQUEST
REQST
RMUCLIENT RMU_CLIENT
ROOT_AREA DUMMY_ROOT_AREA
RO_L1 L1_SNAP_TRUNCATION
RTUPB RTUPB
RUJBLK RUJBLK
RW_L2 L2_SNAP_TRUNCATION
SAC SNAP_AREA_CURSOR
SEQBLK SEQBLK
STAREA STORAGE_AREA, PAREA
STATRQST STATISTICS_REQUEST
TRM TERMINATION
TSNBLK TSNBLK
UTILITY UTILITY
The RESOURCE_TYPE qualifier is incompatible with the MODE, LIMIT,
LOCK and PROCESS qualifiers.