V$PROCESS
This view displays information about the currently active processes.
Fields
The most relevant view fields are as follows:
PID
: An Oracle process identifierSPID
: The operating system process identifierADDR
: The address of the process state objectSERIAL#
: The process serial numberPNAME
: The name of the processUSERNAME
: The operating system process usernameTERMINAL
: The operating system terminal identifierPROGRAM
: The program currently in progress
See also
- The
V$SESSION
section in this appendix
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.