Above mentioned command hangs.
10046 output ( obviously dict lock ; user PRECISE is always connected;
simple test on changing pwd for any other active user works ):

alter user PRECISE_I3 ide
END OF STMT

PARSE #1:c=0,e=899,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=3,ti m=2490292516221

BINDS #1:

WAIT #1: nam='row cache lock' ela= 2937083 p1=7 p2=0 p3=5

WAIT #1: nam='row cache lock' ela= 2939237 p1=7 p2=0 p3=5

WAIT #1: nam='row cache lock' ela= 2939279 p1=7 p2=0 p3=5

WAIT #1: nam='row cache lock' ela= 2939307 p1=7 p2=0 p3=5

WAIT #1: nam='row cache lock' ela= 2939288 p1=7 p2=0 p3=5

WAIT #1: nam='row cache lock' ela= 2939268 p1=7 p2=0 p3=5



Regards, Ranko

<Ranko.Mosic (AT) gmail (DOT) com> wrote


Did you check MetaLink?
Bug 4446011 looks similar (it's about concurrently performing truncate and
'alter user' operations, check if this is you case).

Note 4446011.8.

Regards,
Dimitre