溫馨提示×

您好，登錄后才能下訂單哦！

密碼登錄×
登錄注冊(cè)×
其他方式登錄
點(diǎn)擊 登錄注冊(cè) 即表示同意《億速云用戶服務(wù)條款》

V$PROCESS視圖

發(fā)布時(shí)間：2020-06-30 03:10:30 來源：網(wǎng)絡(luò) 閱讀：291 作者：onlinekof2001 欄目：關(guān)系型數(shù)據(jù)庫

V$PROCESS

V$PROCESS 展示當(dāng)前數(shù)據(jù)庫的活動(dòng)進(jìn)程信息。

ColumnDatatypeDescription
ADDRRAW(4 | 8)Address of the process state object
PIDNUMBEROracle process identifier
SOSIDVARCHAR2(24)Operating system (process, thread) identifier.

This identifier is unique whether the Oracle multiprocess/multithread feature is enabled or not.

SPIDVARCHAR2(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.

STIDVARCHAR2(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_TYPEVARCHAR2(10)Operating system execution type
PNAMEVARCHAR2(5)Name of this process
USERNAMEVARCHAR2(15)Operating system process username
SERIAL#NUMBERProcess serial number
TERMINALVARCHAR2(30)Operating system terminal identifier
PROGRAMVARCHAR2(48)Program in progress
TRACEIDVARCHAR2(255)Trace file identifier
TRACEFILEVARCHAR2(513)Trace file name of the process
BACKGROUNDVARCHAR2(1)1 for a background process; NULL for a normal process
LATCHWAITVARCHAR2(16)Address of the latch the process is waiting for; NULL if none
LATCHSPINVARCHAR2(16)This column is obsolete
PGA_USED_MEMNUMBERPGA memory currently used by the process (in bytes)
PGA_ALLOC_MEMNUMBERPGA 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_MEMNUMBERAllocated PGA memory which can be freed (in bytes)
PGA_MAX_MEMNUMBERMaximum PGA memory ever allocated by the process (in bytes)
CON_IDNUMBERThe 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


向AI問一下細(xì)節(jié)

免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱：is@yisu.com進(jìn)行舉報(bào)，并提供相關(guān)證據(jù)，一經(jīng)查實(shí)，將立刻刪除涉嫌侵權(quán)內(nèi)容。

AI
助
手