V$PROCESS view

V$PROCESS

V$PROCESS shows the active process information of the current database.

ColumnDatatypeDescriptionADDRRAW (4 | 8) Address of the process state objectPIDNUMBEROracle process identifierSOSIDVARCHAR2 (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 typePNAMEVARCHAR2 (5) Name of this processUSERNAMEVARCHAR2 (15) Operating system process usernameSERIAL#NUMBERProcess serial numberTERMINALVARCHAR2 (30) Operating system terminal identifierPROGRAMVARCHAR2 (48) Program in progressTRACEIDVARCHAR2 (255) Trace file identifierTRACEFILEVARCHAR2 (513) Trace file name of the processBACKGROUNDVARCHAR2 (1) 1 for a background process; NULL for a normal processLATCHWAITVARCHAR2 (16) Address of the latch the process is waiting for NULL if noneLATCHSPINVARCHAR2 (16) This column is obsoletePGA_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 bytesPGA_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