Re: kill sessions...

Matthias Rogel wrote:

> DA Morgan wrote:
> > kat wrote:
> >
> >
> >>hi everbody,
> >>
> >>is there a posibility to kill a user session just with the sessionid i
> >>got from dbms_session.unique_user_id and without full dba access? In my
> >>case the user just has full access to one single database.
> >>
> >>thx in advance...
> >>
> >>katharina
> >>
> >>--
> >>Posted via http://dbforums.com
> >
> >
> > There are three ways to kill a session. As you have not given any
> > information with respect to operating system, Oracle version, etc. I am
> > loathe to help you. But here goes.
> >
> > 1. UNIX only ... kill -9 on the session
> >
> >
>
> hi DA,
>
> question:
> are you sure you have to use -9 ?
> what about -1 ?
>
> Matthias
>
> > 2. Windows only... :/oracle/ora81/bin/orakill">c:\oracle\ora81\bin\orakill
> > orabase spid
> >
> > where spid is obtained from the following SQL statement
> >
> > SELECT spid, osuser, s.program, schemaname
> > FROM v$process p, v$session s
> > WHERE p.addr = s.paddr;
> >
> >
> > 3. ALTER SYSTEM KILL SESSION ' 9, 177';
> >
> > In the above example 9 is the sid returned and 177 is the serial# from
> > the following SQL statement
> >
> > SELECT sid, serial#, username, schemaname, osuser
> > FROM v$session;
> >
> > Daniel Morgan
> >

Some of the time -1 will work. All of the time -9 will work.

When you need to kill something ... why not use the high caliber ammunition?

Daniel Morgan Received on Wed Dec 18 2002 - 11:16:38 CST