alter system kill session 'sid,serial#';
where sid and serial# are enclosed by single quotation marks and come from v$session for the user session you want to kill. You can't kill your current session in this manner. You may want to go out to the system (you're on UNIX?) and kill the process.




Reply With Quote