Search notes:

Oracle: V$PROCESS

v$process shows process related information. 
select
   prc.*
from
   v$session  ses                          join
   v$process  prc on ses.paddr = prc.addr
where
   ses.sid = sys_context('userenv', 'sid') 
;

select
  prc.pid,
  prc.serial#,
  prc.program,
  bgp.description bg_process,
  pxp.status      px_status
from
  v$process     prc                        left join
  v$px_process  pxp on prc.pid  = pxp.pid  left join
  v$bgprocess   bgp on prc.addr = bgp.paddr;
Github repository oracle-patterns, path: /Installed/dynamic-performance-views/process/joins.sql

Columns

ADDR
PID
SOSID OS process or thread identifier. Unique
SPID OS process identifier
STID OS thread identifier (unique on Linux and aix, not unique on Solaris)
EXECUTION_TYPE
PNAME
USERNAME
SERIAL#
TERMINAL
PROGRAM
TRACEID
TRACEFILE Path of the trace file
BACKGROUND Background proceses are identified by the number 1, foreground processes by a null. See also v$bgprocess.
LATCHWAIT
LATCHSPIN Obsolete
PGA_USED_MEM PGA memory currently used by the process (unit is bytes)
PGA_ALLOC_MEM Allocated PGA memory
PGA_FREEABLE_MEM Allocated PGA memory that can be freed.
PGA_MAX_MEM Maximum amount of memory that was used.
NUMA_DEFAULT
NUMA_CURR
CPU_USED
CON_ID

traceid

The column traceid is equal to the value used in 
alter session set tracefile_identifier = 'findMe';

See also

v$process_memory_detail
v$px_process
Oracle Dynamic Performance Views

Index