Search notes:
Oracle: V$PROCESS
v$process shows
process related information.
select
prc.*
from
v$session ses join
v$process prc on ses.paddr = prc.addr
where
ses.sid = sys_context('userenv', 'sid')
;
select
prc.pid,
prc.serial#,
prc.program,
bgp.description bg_process,
pxp.status px_status
from
v$process prc left join
v$px_process pxp on prc.pid = pxp.pid left join
v$bgprocess bgp on prc.addr = bgp.paddr;
Columns
ADDR | |
PID | |
SOSID | OS process or thread identifier. Unique |
SPID | OS process identifier. This value is useful when attaching gdb to a process. |
STID | OS thread identifier (unique on Linux and aix, not unique on Solaris) |
EXECUTION_TYPE | |
PNAME | |
USERNAME | |
SERIAL# | |
TERMINAL | |
PROGRAM | |
TRACEID | |
TRACEFILE | Path of the trace file |
BACKGROUND | Background proceses are identified by the number 1, foreground processes by a null. See also v$bgprocess. |
LATCHWAIT | |
LATCHSPIN | Obsolete |
PGA_USED_MEM | PGA memory currently used by the process (unit is bytes) |
PGA_ALLOC_MEM | Allocated PGA memory |
PGA_FREEABLE_MEM | Allocated PGA memory that can be freed. |
PGA_MAX_MEM | Maximum amount of memory that was used. |
NUMA_DEFAULT | |
NUMA_CURR | |
CPU_USED | |
CON_ID | |