[Oracle] v $ process

[Oracle] v $ process

First, check which columns exist in v $ process

SYS @ ORCL> desc v $ process

Name Null? Type

-----------------------------------------------------------------------------

Addr raw (4)

PID NUMBER

SPID VARCHAR2 (12)

USERNAME VARCHAR2 (15)

SERIAL # NUMBER

TERMINAL VARCHAR2 (30)

PROGRAM VARCHAR2 (48)

TRACEID VARCHAR2 (255)

BACKGROUND VARCHAR2 (1)

LATCHWAIT VARCHAR2 (8)

LATCHSPIN VARCHAR2 (8)

PGA_USED_MEM NUMBER

PGA_ALLOC_MEM NUMBER

PGA_FREEABLE_MEM NUMBER

PGA_MAX_MEM NUMBER

ADDR: the memory address of the process, which is associated with the PADDR in the v $ session.

PID -- ID of the process

SPID -- ID of the corresponding Operating System

USERNAME -- user name corresponding to the operating system process, not the Oracle user name

SERIAL # -- Process serial number

TERMINAL -- the Operating System terminal identifier (e.g., computer name ).

PROGRAM -- similar to the PROGRAM in v $ session

TRACEID--TRACE File ID

BACKGROUND--1 indicates oracle background process, and null indicates normal process.

LATCHWAIT -- Address of latch the process is waiting for; NULL if none

LATCHSPIN -- Address of the latch the process is spinning on; NULL if none

PGA_USED_MEM -- PGA memory used by the current process

PGA_ALLOC_MEM -- current allocated PGA memory size (including free PGA memory not yet released to the operating system by the server process)

PGA_FREEABLE_MEM -- idle PGA

PGA_MAX_MEM -- maximum PGA size allowed by the System