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