V$PROCESS

Columns
   ___________________________
 
   ADDR
   PID
   SPID
   USERNAME
   SERIAL#
   TERMINAL
   PROGRAM
   TRACEID
   BACKGROUND
   LATCHWAIT
   LATCHSPIN
   PGA_USED_MEM
   PGA_ALLOC_MEM
   PGA_FREEABLE_MEM
   PGA_MAX_MEM

Related:

V$ACCESS
V$MYSTAT 
V$SESSION 
V$SESSION_CONNECT_INFO 
V$SESSION_CURSOR_CACHE 
V$SESSION_EVENT 
V$SESSION_LONGOPS 
V$SESSION_OBJECT_CACHE 
V$SESSION_WAIT 
V$SESSTAT 
V$SESS_IO