v$process 性能视图,查看 oracle数据库 当前服务进程情况
v$process
视图,作用: v$process
视图包含当前系统oracle运行的所有进程信息,没有客户端程序相关的信息。
常被用于将oracle或服务进程的操作系统进程ID与数据库session之间建立联系。
select * from v$process;
字段说明如下
Column | Datatype | Description |
---|---|---|
ADDR | `RAW(4 | 8)` |
PID | NUMBER | Oracle process identifier Oracle进程ID |
SOSID | VARCHAR2(24) | Operating system (process, thread) identifier. 操作系统(进程、线程)标识符 This identifier is unique whether the Oracle multiprocess/multithread feature is enabled or not.无论是否启用 Oracle 多进程/多线程特性,此标识符都是唯一的。 |
SPID | VARCHAR2(24) | Operating system process identifier. 操作系统进程ID The Oracle multiprocess/multithread feature is available for UNIX systems.Oracle 多进程/多线程特性可用于 UNIX 系统。 When the Oracle multiprocess/multithread feature is enabled, RDBMS processes are mapped to threads running in operating system processes, and the SPID identifier is not unique for RDBMS processes.当启用 Oracle 多进程/多线程特性时,RDBMS 进程被映射到在操作系统进程中运行的线程,而且 SPID 标识符对于 RDBMS 进程并不唯一。When the Oracle multiprocess/multithread feature is not enabled on UNIX systems, the SPID identifier is unique for RDBMS processes.在 UNIX 系统上未启用 Oracle 多进程/多线程特性时,SPID 标识符对于 RDBMS 进程是唯一的。 |
STID | VARCHAR2(24) | Operating system thread identifier. 操作系统线程标识符 The Oracle multiprocess/multithread feature is available for UNIX systems.Oracle 多进程/多线程特性可用于 UNIX 系统。 When the Oracle multiprocess/multithread feature is enabled, RDBMS processes are mapped to threads running in operating system processes, and the SPID and STID together uniquely identify an RDBMS process.当 Oracle 多进程/多线程特性被启用时,RDBMS 进程被映射到在操作系统进程中运行的线程,并且 SPID 和 STID 一起唯一地标识一个 RDBMS 进程。The STID is not unique on Solaris. The STID is unique on Linux and AIX.STID 在 Solaris 上并非唯一的,而是在 Linux 和 AIX 上唯一的。 |
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 对于后台进程; 对于正常进程为 NULL |
LATCHWAIT | VARCHAR2(16) | Address of the latch the process is waiting for; NULL if none 进程正在等待的锁存器的地址; 如果没有,则为 NULL |
LATCHSPIN | VARCHAR2(16) | This column is obsolete 这个专栏已经过时了 |
PGA_USED_MEM | NUMBER | PGA memory currently used by the process (in bytes) 当前进程使用的 PGA 内存(以字节为单位) |
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 内存(包括尚未由服务器进程释放到操作系统的空闲 PGA 内存) ,以字节为单位 |
PGA_FREEABLE_MEM | NUMBER | Allocated PGA memory which can be freed (in bytes) 分配的 PGA 内存可以释放(以字节为单位) |
PGA_MAX_MEM | NUMBER | Maximum PGA memory ever allocated by the process (in bytes) 进程分配的最大 PGA 内存(以字节为单位) |
CON_ID | NUMBER | The ID of the container to which the data pertains. Possible values include: 数据所属容器的 ID。可能的值包括:0 : This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.0: 此值用于包含属于整个 CDB 的数据的行。此值也用于非 CDB 中的行。1 : This value is used for rows containing data that pertain to only the root1: 此值用于包含仅属于根的数据的行n: Where n is the applicable container ID for the rows containing dataN: 其中 n 是包含数据的行的适用容器 ID select count(*) from v$session; |