Locking Information

Information from V$Enqueue_Stat

Instance Number Enqueue Type Total Number of Enqueue Requests/Conversions Total Number of Wait for Enqueue Request/Conversion Number of Times Enqueue Request/Coversion granted Number of Times Enqueue Request/Coversion failed Time(milliseconds) waiting for Enqueue Request/Conversion
1 CF 1443471 623 1443447 24 99240
1 KO 3987 313 3987 0 54340
1 UL 74 18 74 0 31240
1 RO 5049 540 5049 0 28600
1 TQ 571 5 571 0 1460
1 TC 80 16 80 0 250
1 TX 185169 5 185170 0 20
1 HW 109910 5 109910 0 10
1 PE 22 0 22 0 0
1 TA 2182 0 2182 0 0
1 DL 1240 0 1240 0 0
1 SR 862 0 862 0 0
1 KT 1 0 1 0 0
1 PW 20 0 1 19 0
1 WL 810 0 474 336 0
1 XR 135 0 135 0 0
1 SS 1 0 1 0 0
1 SQ 560 3 560 0 0
1 PF 24 0 24 0 0
1 OW 1 0 1 0 0
1 IT 128 0 128 0 0
1 IA 1 0 1 0 0
1 WP 8 0 8 0 0
1 RR 2 0 2 0 0
1 KM 2 0 2 0 0
1 PD 1064 0 1064 0 0
1 SW 3 0 3 0 0
1 CT 23 0 23 0 0
1 US 560 0 560 0 0
1 TD 1184 0 1184 0 0
1 JS 4151856 1 4151856 0 0
1 DT 91 0 91 0 0
1 TS 1592 0 1592 0 0
1 TT 165113 0 165113 0 0
1 CN 5 0 5 0 0
1 JD 132799 0 132799 0 0
1 SE 45715 0 45715 0 0
1 MW 361 0 361 0 0
1 AF 1515 0 1515 0 0
1 TL 1 0 1 0 0
1 PV 401 0 401 0 0
1 AS 4 0 4 0 0
1 DS 2 0 2 0 0
1 BR 59 0 59 0 0
1 MN 9 0 9 0 0
1 TM 368346 0 368286 39 0
1 FB 8807 1 8807 0 0
1 JQ 3099 0 3099 0 0
1 MD 256 0 256 0 0
1 TO 476 0 476 0 0
1 PR 577 0 577 0 0
1 MR 24507 0 24507 0 0
1 SK 2 0 2 0 0
1 DP 1 0 1 0 0
1 WF 4018 0 4015 3 0
1 TB 1 0 1 0 0
1 SH 181 0 181 0 0
1 RS 3592 0 3592 0 0
1 CU 41254 0 41254 0 0
1 KP 18 0 18 0 0
1 CI 7484 0 7484 0 0
1 PG 197 0 197 0 0
1 IS 4752 0 4752 0 0
1 RT 1 0 1 0 0
1 DR 361 0 361 0 0
1 FU 16 0 16 0 0

Back to top