Database Administration (MOSC)

MOSC Banner

V$LOCK TYPE CR in 12.2

edited Mar 9, 2020 1:41PM in Database Administration (MOSC) 3 commentsAnswered ✓

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 --

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center