Re: drop user hangs

Rainer Herbst <rherbst_@_rz.uni-potsdam.de> wrote in message news:<bifsrn$oou$1_at_zeppelin.rz.uni-potsdam.de>...
> Yong Huang schrieb:
> > Rainer Herbst <rherbst_@_rz.uni-potsdam.de> wrote in message news:<bif59m$i3m$1_at_zeppelin.rz.uni-potsdam.de>...
> >
> >>>>3. user was created after the instance started, but the user is
> >>>>definatly not logged in!
> >>>>--> the drop user statement hangs without any complains or error messages!
> >>>
> >>>
> >>>Hangs for ever? You're right that you can't drop a user if they are logged
> >>>in, so how are you certain that they are not logged in? When you say it
> >>>hangs, and produces no error message, have you nevertheless checked the
> >>>alert log for any possible warning messages.
> >>>
> >>
> >>No errors or warnings in the alert log. V$SESSION_WAIT shows the 'null
> >>event' for this session.
> >
> >
> > Can you show us p1,p2,p3 for this "null" event? If they change with
> > time, what do they change to? 9i has the bug that lumps some other
> > events into a null event. But we may be able to guess based on the
> > patterns of their parameters.
>
> 1 select sid, event, p1, p2, p3 , seconds_in_wait
> 2* from v$session_wait where sid=14
>
> SID EVENT
> P1 P2
> P3 SECONDS_IN_WAIT
> ----------
> ----------------------------------------------------------------
> ---------- ---------- ---------- ---------------
> 14 null event
> 1650815232 1
> 0 1500
>
> I haven't seen any changes in p1, p2 and p3.

OK. This looks like the "useless" event "SQL*Net message to client". You need to set sql_trace true for the DROP USER command to find out more. Looks like your oracletool.pl doesn't do that job.

Yong Huang Received on Tue Aug 26 2003 - 17:11:32 CDT