Examples |
 |
To set the lock filter to the default value, you would
enter
SQLMONITOR LOCK => SET LOCKFILTER ////
|
To display only those locks for which one or more sessions
are waiting, enter
SQLMONITOR LOCK => SET LOCKFILTER //WC//
|
The next example displays only those locks that
are table locks or page locks
are held by sessions that are waiting to acquire or convert locks
are either exclusive, intent exclusive, or share plus intent exclusive
SQLMONITOR LOCK => SET LOCKFILTER U/TP/WC/Xx6/1
|
Since you can enter the characters within a filter parameter
in any order, the two commands in the following example are
equivalent:
SQLMONITOR LOCK => SET LOCKFILTER ///SX6/
|
SQLMONITOR LOCK => SET LOCKFILTER ///6SX/
|
If you omit the last parameter, SQLMON prompts for it, as follows:
SQLMONITOR LOCK => SET LOCKFILTER
PRESS <RETURN> TO SELECT ALL ITEMS FOR EACH PROMPT
TABLES <(S)ystem (U)ser > : U
GRANULARITY <(T)able (P)age (R)Row > : T P
LOCK STATUS <(G)ranted (W)aiting (C)onverting > : W
LOCK MODES <(S)Share (X)Exclusive (R)ecovry Excl
(s)IS (x)IX (r)RIX
(6)SIX (v)RSIX > :
QUEUE LENGTH <integer value greater than 0 > : 2
The current setting for the LOCKFILTER is:
TABLES : (U)SER
GRANULARITY : (T)ABLE (P)AGE
LOCK STATUS : (W)AITING
LOCK MODES : (S)SHARE (X)EXCLUSIVE (R)ECOVRY EXCL
(s)IS (x)IX (r)RIX
(6)SIX (v)RSIX
QUEUE LENGTH : 2
|