V$PROCESS视图
V$PROCESS
V$PROCESS 展示当前数据库的活动进程信息。
| Column | Datatype | Description |
|---|---|---|
ADDR |
RAW(4 |
8) |
Address of the process state object |
PID |
NUMBER |
Oracle process identifier |
SOSID |
VARCHAR2(24) |
Operating system
(process, thread) identifier. This identifier is unique whether the Oracle multiprocess/multithread feature is enabled or not. |
SPID |
VARCHAR2(24) |
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 |
STID |
VARCHAR2(24) |
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 |
EXECUTION_TYPE |
VARCHAR2(10) |
Operating system execution type |
PNAME |
VARCHAR2(5) |
Name of this process |
USERNAME |
VARCHAR2(15) |
Operating system process username |
SERIAL# |
NUMBER |
Process serial number |
TERMINAL |
VARCHAR2(30) |
Operating system terminal identifier |
PROGRAM |
VARCHAR2(48) |
Program in progress |
TRACEID |
VARCHAR2(255) |
Trace file identifier |
TRACEFILE |
VARCHAR2(513) |
Trace file name of the process |
BACKGROUND |
VARCHAR2(1) |
1 for a background process; NULL for a normal process |
LATCHWAIT |
VARCHAR2(16) |
Address of the latch the process is waiting for; NULL if none |
LATCHSPIN |
VARCHAR2(16) |
This column is obsolete |
PGA_USED_MEM |
NUMBER |
PGA memory currently used by the process (in bytes) |
PGA_ALLOC_MEM |
NUMBER |
PGA memory currently allocated by the process (including free PGA memory not yet released to the operating system by the server process), in bytes |
PGA_FREEABLE_MEM |
NUMBER |
Allocated PGA memory which can be freed (in bytes) |
PGA_MAX_MEM |
NUMBER |
Maximum PGA memory ever allocated by the process (in bytes) |
CON_ID |
NUMBER |
The ID of the
container to which the data pertains. Possible values include:
|