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
>
>



Oracle LazyDBA home page