Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: kill sessions...
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
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