How to Locate Database Process on OS

This script will map database process to the operating system process (spid), provide username and program (sqlplus, java etc...):

select p.spid, s.username, s.program
from v$process p, v$session s
where p.addr=s.paddr order by 2, 3, 1
/