Dynamic Performance (V$) Views, 109 of 179

V$PROCESS

This view contains information about the currently active processes. While the LATCHWAIT column indicates what latch a process is waiting for, the LATCHSPIN column indicates what latch a process is spinning on. On multi-processor machines, Oracle processes will spin on a latch before waiting on it.

Column Datatype Description

ADDR

RAW(4)

Address of process state object

PID

NUMBER

Oracle process identifier

SPID

VARCHAR2

Operating system process identifier

USERNAME

VARCHAR2

Operating system process username. Any Two-Task user coming across the network has "-T" appended to the username.

SERIAL#

NUMBER

Process serial number

TERMINAL

VARCHAR2

Operating system terminal identifier

PROGRAM

VARCHAR2

Program in progress

BACKGROUND

VARCHAR2

1 for a background process; NULL for a normal process

LATCHWAIT

VARCHAR2

Address of latch the process is waiting for; NULL if none

LATCHSPIN

VARCHAR2

Address of latch the process is being spun on; NULL if none

Column	Datatype	Description
`ADDR`	`RAW(4)`	Address of process state object
`PID`	`NUMBER`	Oracle process identifier
`SPID`	`VARCHAR2`	Operating system process identifier
`USERNAME`	`VARCHAR2`	Operating system process username. Any Two-Task user coming across the network has "-T" appended to the username.
`SERIAL#`	`NUMBER`	Process serial number
`TERMINAL`	`VARCHAR2`	Operating system terminal identifier
`PROGRAM`	`VARCHAR2`	Program in progress
`BACKGROUND`	`VARCHAR2`	1 for a background process; NULL for a normal process
`LATCHWAIT`	`VARCHAR2`	Address of latch the process is waiting for; NULL if none
`LATCHSPIN`	`VARCHAR2`	Address of latch the process is being spun on; NULL if none