Re: How do I kill a user's session?

alter system kill session 'sid,serial#';

you need to get sid and serial# from v$session first, for instance by select sid, serial#, program, audsid, osusername from v$session
where type = 'USER'
/
Hth,

--
Sybrand Bakker, Oracle DBA
Calvin Crumrine <Calvin_Crumrine_at_dced.state.ak.us> wrote in message news:385544DC.8B17825A_at_dced.state.ak.us...
> Running SQL*Loader, a user fails with an internal error that appears to
end SQL*Loader without
> unlocking the table.
>
> Since I'm certain similar situations will arise from other actions, my
preferred solutions
> would be to kill the user's session, thus freeing up all resources it has
locked.
>
> Although I've been designated 'DBA' the only training I was given was
before they bought the
> server. By now I've forgotten half of what I was taught, and this might be
part of it.
>
> Is there a way to kill a user's session?
>
> Thanks.
Received on Mon Dec 13 1999 - 13:33:31 CST