V$LOCK TYPE CR in 12.2
I am trying to run "drop user x cascade" and the drop appears blocked by lock type of "CR" which does not appear in the manual. Version is 12.2.0.1.0.
- -
Enter value for session: 276
Time Held
SID TY ID1 ID2 Mode Held Mode Req Waited BLOCKING
------ -- ---------- ---------- --------- --------- ---------- --------
276 AE 133 0 Share None 0 Distr
276 TS 20 85512563 Exclusive None 0 Distr
276 TO 202892 1 Row Exc None 0 Distr
276 TO 202888 1 Row Exc None 0 Distr
276 UL 1073743007 0 Exclusive None 0 Distr
276 TT 20 16 Share None 0 Distr
276 UL 1073743006 0 Exclusive None 0 Distr
276 UL 1073743005 0 Exclusive None 0 Distr
276 TO 202890 1 Row Exc None 0 Distr
276 CR 65657 1 Shr Row X Exclusive 0 Distr
276 TS 20 85512562 Exclusive None 0 Distr
HTH -- Mark D Powell --