run under privilege user (dba, sys, system) in sqlplus or svrmgrl for all
unneeded users:

alter system kill session 'sid,serial#';


to find out all users, try this script:

select sid,serial#,status,to_char(logon_time,'dd/mm/yy hh24:mi:ss'),
process,osuser,schemaname,substr(machine,1,15)MACHINE,program,
module,terminal
from v$session
where schemaname != 'SYS';


Ofer

-----Original Message-----
From: Shibashish
[mailto:oracledba-ezmlmshield-x39645869.[Email address protected]
Sent: Tuesday, September 14, 2004 10:31 AM
To: LazyDBA Discussion
Subject: Re: Kill a user


open dbastudio

in unix/linux "oemapp dbastudio"

Navigate to network>databases>(yourSID)> login as sys .. as sysdba > expand
Instance (click on +) > Sessions

On the right pane, find all active sessions. Right click on any active
session, and select the "Kill Session > Immediate" option.

Hope this helps.

--Shib


----- Original Message -----
From: "Sathiya " <oracledba-ezmlmshield-x1075487.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, September 14, 2004 1:34 PM
Subject: Kill a user


> Dear All,
>
> I need a help from you. One of my user's machine got struck
> up and we rebooted the system. Now the User name is listed
> in v$session which we could not shutdown the database. Is
> there any way to kill that user_id from the session. I can do this
> by shutting down the ORacle services and restart which I dont
> want to do it through this.. Please help
>
> Regards
> Sathiya
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


**********************************************************************
The information contained in this e-mail message may be
privileged and confidential. The information is intended only
for the use of the individual or entity named above. If the
reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying
of this communication is strictly prohibited. If you have
received this communication in error, please notify us
immediately by telephone, or by e-mail and delete the message
from your computer. Thank you!
Unless otherwise stated, any views or opinions expressed in
this e-mail are solely those of the author and do not represent those of
Barak I.T.C (1995) The International Telecommunications Services Corp. Ltd.
**********************************************************************


Oracle LazyDBA home page