Oracle's v$process detailed

First see what 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 address of the memory corresponding to the process, associating the paddr in the V$session

pid--The process's ID number

spid--ID number of the corresponding operating system

The user name of the username--operating system process, not the Oracle username

Serial#--process Serial Number

terminal--operating system TERMINAL identifier (e.g., computer name).

program--and V$session are similar to the program inside.

ID number of the Traceid--trace file

The background--1 represents the normal process on behalf of the Oracle BACKGROUND Process,null.

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--the PGA memory used by the current process

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

pga_freeable_mem--free PGA

Maximum PGA size allowed by the pga_max_mem--system

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/