Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to kill particular Oracle Session from the multiple Session of User

540341Oct 18 2006 — edited Oct 19 2006

Hi,

I am working on Web Application using ASP.NET , C# with Oracle. I am excuting queries from multiple connection of same user. I want to kill particular user session. I have tried to Kill session by using ALTER SYSTEM KILL SESSION 'sid,serial#' it is working fine but how can i identify which session is generated by particular connection so that i can kill that particular session.

Suppose there us user 'abc' there are multple instance of this user and all are active but same USERNAME. So Please tell me how can i identify that session through which i am executing the query.

Thanks,
Nitin

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 16 2006

Added on Oct 18 2006

#general-database-discussions

4 comments

1,148 views