forcing a user to disconnect

How do I force a user to disconnect from the Oracle system 7.3.3.5 under unix?
glow060197Asked:
Who is Participating?
 
rpullella12Connect With a Mentor Commented:
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.  

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

glow
0
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.

All Courses

From novice to tech pro — start learning today.