• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3324
  • Last Modified:

forcing a user to disconnect

How do I force a user to disconnect from the Oracle system under unix?
  • 2
1 Solution
glow060197Author Commented:
Edited text of question
Here are the options :

1.  Find the unix username, specific unix process(pid) for the oracle connection (ps -ef), kill the session with kill -9 <pid>

2.  Login as DBA/svrmgr, query the v$session view
    where username = <DB user_name>.  Get the values for sid and
    serial# columns, issue the command
    alter system kill session 'sid, serial#' ;

Ensure the process size is manageable to fit within the available rollback segments.  

glow060197Author Commented:
wow you answered my question 20 minutes after i posted it.  thanks for the help

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now