V$PROCESS

This view displays information about the currently active processes.

Fields

The most relevant view fields are as follows:

• PID: An Oracle process identifier

• SPID: The operating system process identifier

• ADDR: The address of the process state object

• SERIAL#: The process serial number

• PNAME: The name of the process

• USERNAME: The operating system process username

• TERMINAL: The operating system terminal identifier

• PROGRAM: The program currently in progress

See also

• The V$SESSION section in this appendix