DBA Data[Home] [Help]

VIEW: SYS.GV_$PROCESS

Source

View Text - Preformatted

select "INST_ID","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 gv$process
View Text - HTML Formatted

SELECT "INST_ID"
, "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 GV$PROCESS