Find Username and SPID !

Find Username and SPID :
------------------------

select a.username,a.sid,b.spid from v$session a, v$process b where a.sid = '1638634'

select a.username,a.sid,b.spid from v$session a, v$process b where a.serial# = b.serial#

Here , 'SPID' of the Database is equivalent the 'process id' of oracle processes .We get the process id using below commands :

"ps -ef | grep oracle"

If we need to kill it then give the below command :

kill -9 "procee id" //In both Linux and AIX environment .