Oracle 视图 V$PROCESS 官方解释，作用，如何使用详细说明
本站中文解释
V$PROCESS 视图是Oracle数据库的一个系统视图，它提供有关数据库服务器和客户机进程的详细信息。可以通过V$PROCESS视图查询数据库服务器上运行的每个进程信息。其中包括会话ID，进程ID，服务，登录帐户，会话状态，当前活动，运行程序，活动类型，会话来源等等。
使用这个视图，可以查看当前的会话，定位某个会话的详细情况，检查会话执行哪个进程等。此外，也可以执行动态性能查询，检查数据库系统是否受到影响。
要使用V$PROCESS视图查询数据库服务器上运行的每个进程信息，可以使用如下SQL语句：
SELECT *
FROM 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:
|
