Finding the O/S process that is running your Oracle process    Sept 6th 2008

For many reasons, you may want to know the Operating System Process ID that is responsible for running your Oracle process.  Sometimes it might be needed to use O/S command to kill the process.

The following command will just do that


 SQL> select p.spid,s.username usrname
     from v$process p, v$session s
     where p.addr=s.paddr
     and s.username=user;