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 SPID identifier is not unique for RDBMS processes. When the Oracle multiprocess/multithread feature is not enabled on UNIX
systems, the SPID identifier is unique for RDBMS
processes. |
|---|
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 SPID and STID together uniquely identify an
RDBMS process. The STID is not unique on Solaris. The STID is unique on Linux and 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 |
|---|
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: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.
1: This value is used for rows containing data that
pertain to only the root
n: Where n is the
applicable container ID for the rows containing
data
|
|---|
分享文章：V$PROCESS视图
网站地址：
http://cdkjz.cn/article/iishog.html
