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@xxxxxxxxxx http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicMain.html