Databases Reference
In-Depth Information
V$PROCESS
This view displays information about the currently active processes.
Fields
The most relevant view fields are as follows:
F
PID
: An Oracle process identifier
F
SPID
: The operating system process identifier
F
ADDR
: The address of the process state object
F
SERIAL#
: The process serial number
F
PNAME
: The name of the process
F
USERNAME
: The operating system process username
F
TERMINAL
: The operating system terminal identifier
F
PROGRAM
: The program currently in progress
See also
F
The
V$SESSION
section in this appendix
V$ROLLSTAT
This view contains rollback segments statistics.
Fields
The most relevant view fields are as follows:
F
USN
: The rollback segment number
F
LATCH
: The latch for the rollback segment
F
EXTENTS
: The number of extents in the rollback segment
F
RSSIZE
: The size of the rollback segment in bytes