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/Conversion Granted Number of Times Enqueue Request/Conversion Failed Time(milliseconds) Waiting for Enqueue Request/Conversion
1 UL 2412 8 2412 0 6380
1 CF 151866 22 151864 2 5850
1 RO 4320 353 4320 0 5250
1 KO 10845 592 10845 0 3970
1 TC 20 1 20 0 1060
1 WL 90 1 81 9 350
1 PE 76 0 76 0 0
1 FP 62 0 62 0 0
1 TA 1088 0 1088 0 0
1 DL 92 0 92 0 0
1 SR 397 0 397 0 0
1 TQ 20524 0 20524 0 0
1 KT 1 0 1 0 0
1 PW 9 0 1 8 0
1 XR 78 0 78 0 0
1 SS 1 0 1 0 0
1 SQ 369 0 369 0 0
1 PF 2 0 2 0 0
1 OW 1 0 1 0 0
1 IT 182 0 182 0 0
1 IA 1 0 1 0 0
1 WP 5 0 5 0 0
1 RR 2 0 2 0 0
1 KM 2 0 2 0 0
1 PD 133 0 133 0 0
1 SW 65 0 65 0 0
1 CT 135 0 135 0 0
1 US 217 0 217 0 0
1 TD 630 0 630 0 0
1 DV 579 0 579 0 0
1 JS 2061790 2 2061790 0 0
1 DT 1 0 1 0 0
1 TS 371 0 371 0 0
1 TT 121520 0 121520 0 0
1 CN 5 0 5 0 0
1 JD 69779 0 69779 0 0
1 SE 11973 0 11973 0 0
1 MW 179 0 179 0 0
1 AF 790 0 790 0 0
1 TL 1 0 1 0 0
1 PV 199 0 199 0 0
1 AS 4 0 4 0 0
1 BR 60 0 60 0 0
1 MN 4 0 4 0 0
1 TM 1133786 0 1133623 163 0
1 FB 8389 0 8389 0 0
1 TX 367540 0 367540 0 0
1 JQ 5369 0 5369 0 0
1 MD 240 0 240 0 0
1 TO 850 0 850 0 0
1 PR 2472 0 2472 0 0
1 MR 9229 0 9229 0 0
1 DP 1 0 1 0 0
1 WF 3059 1 3058 1 0
1 TB 1 0 1 0 0
1 SH 89 0 89 0 0
1 RS 297 0 297 0 0
1 CU 51894 0 51894 0 0
1 KP 8 0 8 0 0
1 CI 2210 0 2210 0 0
1 PG 44 0 44 0 0
1 IS 2035 0 2035 0 0
1 RT 1 0 1 0 0
1 HW 76313 0 76313 0 0
1 DR 179 0 179 0 0
1 FU 8 0 8 0 0

Back to top