介绍

V$PROCESS视图能够查询到当前数据库的所有进程信息。

视图详情

字段名	字段类型	官方描述	译	备注
ADDR	RAW(4 | 8)	Address of the process state object	进程状态对象的地址
PID	NUMBER	Oracle process identifier	Oracle进程标识符
SPID	VARCHAR2(24)	Operating system process identifier	操作系统的进程号
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	程序进程名	显示格式：oracle@主机名(进程名)
TRACEID	VARCHAR2(255)	Trace file identifier	跟踪文件的标识符
TRACEFILE	VARCHAR2(513)	Trace file name of the process	进程的跟踪文件名
BACKGROUND	VARCHAR2(1)	1 for a SYSTEM background process; NULL for foreground processes or non-SYSTEM background processes	1-系统后台进程；NULL-前台进程或非后台进程
LATCHWAIT	VARCHAR2(8)	Address of the latch the process is waiting for; NULL if none	进程正在等待锁存的地址，如果没有，则为NULL
LATCHSPIN	VARCHAR2(8)	This column is obsolete	此列已过时	未来Oracle应该会删除此列
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内存(以字节为单位)