DBA Data[Home] [Help]

VIEW: SYS.V_$PROCESS

Source

View Text - Preformatted

select "ADDR","PID","SOSID","SPID","STID","EXECUTION_TYPE","PNAME","USERNAME","SERIAL#","TERMINAL","PROGRAM","TRACEID","TRACEFILE","BACKGROUND","LATCHWAIT","LATCHSPIN","PGA_USED_MEM","PGA_ALLOC_MEM","PGA_FREEABLE_MEM","PGA_MAX_MEM","CON_ID" from v$process
View Text - HTML Formatted

SELECT "ADDR"
, "PID"
, "SOSID"
, "SPID"
, "STID"
, "EXECUTION_TYPE"
, "PNAME"
, "USERNAME"
, "SERIAL#"
, "TERMINAL"
, "PROGRAM"
, "TRACEID"
, "TRACEFILE"
, "BACKGROUND"
, "LATCHWAIT"
, "LATCHSPIN"
, "PGA_USED_MEM"
, "PGA_ALLOC_MEM"
, "PGA_FREEABLE_MEM"
, "PGA_MAX_MEM"
, "CON_ID"
FROM V$PROCESS