V$PROCESS 展示當(dāng)前數(shù)據(jù)庫的活動進程信息。
站在用戶的角度思考問題，與客戶深入溝通，找到焉耆網(wǎng)站設(shè)計與焉耆網(wǎng)站推廣的解決方案，憑借多年的經(jīng)驗，讓設(shè)計與互聯(lián)網(wǎng)技術(shù)結(jié)合，創(chuàng)造個性化、用戶體驗好的作品，建站類型包括：成都網(wǎng)站建設(shè)、做網(wǎng)站、企業(yè)官網(wǎng)、英文網(wǎng)站、手機端網(wǎng)站、網(wǎng)站推廣、申請域名、虛擬主機、企業(yè)郵箱。業(yè)務(wù)覆蓋焉耆地區(qū)。
| 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:
|
重慶分公司
重慶分公司
