8.127 V$PROCESS
V$PROCESS
displays information about the currently active processes.
Column | Datatype | Description |
---|---|---|
|
|
Address of the process state object |
|
|
Oracle process identifier |
|
|
Operating system (process, thread) identifier. This identifier is unique whether the Oracle multiprocess/multithread feature is enabled or not. |
|
|
Operating system process identifier. The Oracle multiprocess/multithread feature is available for UNIX systems. When the Oracle multiprocess/multithread feature is enabled, RDBMS processes are mapped to threads running in operating system processes, and the When the Oracle multiprocess/multithread feature is not enabled on UNIX systems, the |
|
|
Operating system thread identifier. The Oracle multiprocess/multithread feature is available for UNIX systems. When the Oracle multiprocess/multithread feature is enabled, RDBMS processes are mapped to threads running in operating system processes, and the The |
|
|
Operating system execution type |
|
|
Name of this process |
|
|
Operating system process username |
|
|
Process serial number |
|
|
Operating system terminal identifier |
|
|
Program in progress |
|
|
Trace file identifier |
|
|
Trace file name of the process |
|
|
|
|
|
Address of the latch the process is waiting for; NULL if none |
|
|
This column is obsolete |
|
|
PGA memory currently used by the process (in bytes) |
|
|
PGA memory currently allocated by the process (including free PGA memory not yet released to the operating system by the server process), in bytes |
|
|
Allocated PGA memory which can be freed (in bytes) |
|
|
Maximum PGA memory ever allocated by the process (in bytes) |
|
|
The NUMA processor group of this process at initialization time |
|
|
The NUMA processor group of this process currently |
|
|
Tracks the CPU used by this process (in microseconds) from the time it was spawned |
|
|
The ID of the container to which the data pertains. Possible values include:
|