v$process

Join v$process's addr with v$session's paddr

Column Usage

ADDR Oracle address of the process

PID Oracle process ID

SPID OS system process ID

USERNAME OS process owner

SERIAL# Oracle process serial #

TERMINAL OS terminal identifier

PROGRAM OS program connection

BACKGROUND 1 for background process
NULL for user process

Column	Usage
ADDR	Oracle address of the process
PID	Oracle process ID
SPID	OS system process ID
USERNAME	OS process owner
SERIAL#	Oracle process serial #
TERMINAL	OS terminal identifier
PROGRAM	OS program connection
BACKGROUND	1 for background process NULL for user process

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ADDR                                               RAW(8)
 PID                                                NUMBER
 SPID                                               VARCHAR2(12)
 USERNAME                                           VARCHAR2(15)
 SERIAL#                                            NUMBER
 TERMINAL                                           VARCHAR2(30)
 PROGRAM                                            VARCHAR2(48)
 TRACEID                                            VARCHAR2(255)
 BACKGROUND                                         VARCHAR2(1)
 LATCHWAIT                                          VARCHAR2(16)
 LATCHSPIN                                          VARCHAR2(16)
 PGA_USED_MEM                                       NUMBER
 PGA_ALLOC_MEM                                      NUMBER
 PGA_FREEABLE_MEM                                   NUMBER
 PGA_MAX_MEM                                        NUMBER