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:
|
