Re: kill sessions...

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
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 Tue Dec 17 2002 - 11:33:47 CST