Global contention
-----------------------------------------------------------------------------
L-LOCKS 0:00:00.000000 0 N/P
PARENTS 0:00:00.000000 0 N/P
CHILD 0:00:00.000000 0 N/P
OTHER 0:00:00.000000 0 N/P
P-LOCKS 0:00:00.000000 0 N/P
PAGESET PARTITION 0:00:00.000000 0 N/P
PAGE 0:00:00.000000 0 N/P
OTHER 0:00:00.000000 0 N/P
The following tables describes the fields in the Global contention section:
Field | Description |
|---|---|
Section 1 | |
L-LOCKS | Accumulated global contention wait time for all L-Locks |
PARENT | Accumulated global contention waits time for all L-Locks |
CHILD | Accumulated global contention wait time for child L-Locks |
OTHER | Accumulated global contention wait time for other L-Locks |
P-LOCKS | Accumulated global contention wait time for all P-Locks |
PAGESET PARTITION | Accumulated global contention time for pageset and partition P-Locks |
PAGE | Accumulated global contention wait time for page P-Locks |
OTHER | Accumulated global contention wait time for other P-Locks |
Section 2 | |
L-LOCKS | Number of global contention waits events for all L-Locks |
PARENT | Number of global contention wait events for parent L-Locks |
CHILD | Number of global contention wait events for child L-Locks |
OTHER | Number of global contention wait events for other L-Locks |
P-LOCKS | Number of global contention waits for all P-Locks |
PAGESET PARTITION | Number of global contention waits for pageset and partition P-Locks |
PAGE | Number of global contention waits for page P-Locks |
OTHER | Number of global contention waits for other P-Locks |
Field | Description |
|---|---|
L-LOCKS | Number of global contention waits events for all L-Locks |
PARENT | Number of global contention wait events for parent L-Locks |
CHILD | Number of global contention wait events for child L-Locks |
OTHER | Number of global contention wait events for other L-Locks |
P-LOCKS | Number of global contention waits for all P-Locks |
PAGESET PARTITION | Number of global contention waits for pageset and partition P-Locks |
PAGE | Number of global contention waits for page P-Locks |
OTHER | Number of global contention waits for other P-Locks |