Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: kill sessions...

Re: kill sessions...

From: Matthias Rogel <rogel_at_web.de>
Date: Wed, 18 Dec 2002 07:26:02 +0100
Message-ID: <atp4dq$12tmg$1@ID-86071.news.dfncis.de>


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
>
Received on Wed Dec 18 2002 - 00:26:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US