killing oracle processes again !

[smacattack]

I understand how to kill the process through
alter system kill session `sid,serial#`
but this will leave the oracle process in unix, this is not user unique as it only shows oraclexxxxx as name, the unix pid is the unique part.
How to i tie-up the unix process and the oracle sid,serial# and kill all processes cleanly?

 

[MikeJones]

I was always under the impression that Oracle tidied up any extra processes correctly? Can you give an example of the alter system kill session command you issue and the oraclexxxxx unix command that this leaves running

 

[smacattack]

The example of the alter kill session is shown on previous message but what is left behind on unix is oracle 13087 1 0 08:42:17 ? 0:05 oraclelive (DESCRIPTION=(LOCAL=no
)(ADDRESS=(PROTOCOL=BEQ)))
Somehow oracle will be able to tie the pid number ie 13087 into the sid and serial# and from this you should be able to determine which unix process has been spawned and
kill -9 <pid-id>.

 

[sem]

select s.SID, s.SERIAL#, p.SPID OS_PID
from v$session s, v$process p
where s.paddr = p.addr and some_conditions_to_locate_session_or_process