Re: Dropping user with logged in sessions

On Feb 6, 5:13 pm, "gazzag" <gar..._at_jamms.org> wrote:
> On 6 Feb, 15:53, hasta..._at_hotmail.com wrote:
>
> > Is there an upper bound for the time needed
> > to actually kill a session at the oracle level ?
>
> In my experience, the ALTER SYSTEM KILL SESSION statement will set the
> STATUS of the session involved to KILLED. It may well take some time
> before Oracle clears down these sessions, however, a schema with
> KILLED sessions can be dropped from the database.
Gazzag,

tnx for this insight, I was allready wondering how oracle signalled a killed session.
Next time a session has been altered I will have a look at v $session.status.

regards,
Martijn

>
> HTH
>
> -g
Received on Wed Feb 07 2007 - 02:49:42 CST