kdefilip
Member
See below:What to do about this depends on which latch or latches show contention.
NOTE: *** I/O timing is not enabled. ***
♀10/23/14 Activity: Latch Counts
07:58:14 10/05/14 11:27 to 10/23/14 07:57 (428 hrs 31 min)
----- Locks ----- ------ Busy ------ Naps ---------- Spins ----------- ----- Na
Max -----
Owner Total /Sec /Sec Pct /Sec /Sec /Lock /Busy Total
HWM
MTX -- 486196434 315 0 0.0 1 0 0 0 0 0
USR -- 567916810 368 0 0.0 0 0 0 0 0 0
OM -- 25693552830 16655 0 0.0 0 0 0 0 0 0
BIB -- 605749120 392 0 0.0 0 0 0 0 0 0
SCH -- 21304800 13 0 0.0 0 0 0 0 0 0
LKP -- 1400928027 908 0 0.0 0 0 0 0 0 0
GST -- 328807 0 0 0.0 0 0 0 0 0 0
TXT -- 356911559 231 0 0.0 0 0 0 0 0 0
LKT -- 1716548720 1112 0 0.0 0 0 0 0 0 0
LKT -- 1877837611 1217 0 0.0 0 0 0 0 0 0
LKT -- 1522060612 986 0 0.0 0 0 0 0 0 0
LKT -- 1572079335 1019 0 0.0 0 0 0 0 0 0
SEQ -- 4948253 3 0 0.0 0 0 0 0 0 0
AIB -- 527881663 342 0 0.0 0 0 0 0 0 0
TXQ -- 626367600 406 0 0.0 0 0 0 0 0 0
EC -- 0 0 0 0.0 0 0 0 0 0 0
LKF -- 4316310416 2797 0 0.0 0 0 0 0 0 0
BFP -- 403637787 261 0 0.0 0 0 0 0 0 0
BHT -- 47171345038 30578 0 0.0 0 0 0 0 0 0
PWQ -- 9164695 5 0 0.0 0 0 0 0 0 0
CPQ -- 189623611 122 0 0.0 0 0 0 0 0 0
LRU -- 18762062043 12162 0 0.0 0 0 0 0 0 0
LRU -- 0 0 0 0.0 0 0 0 0 0 0
BUF -- 23942784344 15520 0 0.0 0 0 0 0 0 0
BUF -- 23755477527 15399 0 0.0 0 0 0 0 0 0
BUF -- 22537106234 14609 0 0.0 0 0 0 0 0 0
BUF -- 22834876985 14802 0 0.0 0 0 0 0 0 0
INC -- 0 0 0 0.0 0 0 0 0 0 0
L29 -- 0 0 0 0.0 0 0 0 0 0 0
L30 -- 0 0 0 0.0 0 0 0 0 0 0
L31 -- 0 0 0 0.0 0 0 0 0 0 0