Re: alter user precise indentified by xxxx hangs

From: ???????, <cichomitiko_at_gmail.com>
Date: Mon, 1 May 2006 23:42:34 +0200
Message-ID: <445680ca$0$15791$14726298@news.sunsite.dk>

<Ranko.Mosic_at_gmail.com> wrote in message news:1146508451.165381.216560_at_i39g2000cwa.googlegroups.com...
> 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,tim=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

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 Received on Mon May 01 2006 - 16:42:34 CDT