Kill Oracle session having only UNIX PID

[Stfish]

Having only the UNIX process ID, how can I identify in the V $ session or v $ process session id and serial, so that you can kill the session?

[gilbertoca]

I think here http://download-west.oracle.com/docs/cd ... #sthref628
is a good place to start.

Gilberto

[Stfish]

Gilbertoca,

grateful but, the link in question only shows me how to kill an identicated session.
I am trying to identify the session from the process (PID) of the operating system (UNIX)

[dr_gori]

Try the following:

OS_Process_ID is the UNIX PID:

Select all

Select SID,SERIAL#  
from v$session where paddr in (select addr from v$process where spid='OS_PROCESS_ID'); 

With these values, you can kill

Select all

alter system kill session '<SID>,<SERIAL#>';

Now, can kill in only using

Select all

kill -9 <pid>

but you should not kill the process in just without first killing in Oracle.

: -O

[gilbertoca]

Good Thomas! In this you was faster than me! : lol:

[Stfish]

That was exactly what I was wanting.

grateful !!

[lobo]

Look at this query to check the SID and the serial:

Select all

select d.sid,d.serial#,b.spid,d.status,decode(a.block,1,'SIM',0,'não') BLOCK, 
c.object_name,d.osuser,d.schemaname,d.program 
from v$lock a,dba_objects c, v$session d, v$process b 
where a.sid=d.sid and 
d.paddr=b.addr 
and a.id1=c.object_id(+)  
and d.osuser is not null 
and d.schemaname <> 'SYS' 
order by 1,6