|
ADDR
|
RAW(4 | 8)
|
Address of process state object
|
|
PID
|
NUMBER
|
Oracle process identifier
|
|
SPID
|
VARCHAR2(12)
|
Operating system process identifier
|
|
USERNAME
|
VARCHAR2(15)
|
Operating system process username. Any two-task user coming across the network has "-T" appended to the username.
|
|
SERIAL#
|
NUMBER
|
Process serial number
|
|
TERMINAL
|
VARCHAR2(30)
|
Operating system terminal identifier
|
|
PROGRAM
|
VARCHAR2(48)
|
Program in progress
|
|
TRACEID
|
VARCHAR2(255)
|
Trace file identifier
|
|
BACKGROUND
|
VARCHAR2(1)
|
1 for a background process; NULL for a normal process
|
|
LATCHWAIT
|
VARCHAR2(8)
|
Address of latch the process is waiting for; NULL if none
|
|
LATCHSPIN
|
VARCHAR2(8)
|
Address of the latch the process is spinning on; NULL if none
|
|
PGA_USED_MEM
|
NUMBER
|
PGA memory currently used by the process
|
|
PGA_ALLOC_MEM
|
NUMBER
|
PGA memory currently allocated by the process (including free PGA memory not yet released to the operating system by the server process)
|
|
PGA_FREEABLE_MEM
|
NUMBER
|
Allocated PGA memory which can be freed
|
|
PGA_MAX_MEM
|
NUMBER
|
Maximum PGA memory ever allocated by the process
|
