alter user precise indentified by xxxx hangs

From: Ranko Mosic <ranko.mosic_at_gmail.com>
Date: Mon, 1 May 2006 14:33:37 -0400
Message-ID: <367369f10605011133i5c608a65s89eb0edbcc36f3c4@mail.gmail.com>

Hi List,
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

--

Regards,
Ranko Mosic
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional Phone: 416-450-2785
email: mosicr_at_rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html

--

http://www.freelists.org/webpage/oracle-l Received on Mon May 01 2006 - 13:33:37 CDT