Killing a process

[cam_01]

select sid,serial#,username
from v$session;

To kill a particular session pick its sid,serial#.

Ex.

ALTER SYSTEM KILL SESSION '8,103';

where 8 is the sid and 103 is the serial#.

cheers