This view contains information about the currently active processes. While the LATCHWAIT column indicates what latch a process is waiting for, the LATCHSPIN column indicates what latch a process is spinning on. On multi-processor machines, Oracle processes will spin on a latch before waiting on it.
RAW(4 | 8)
Address of process state object
Oracle process identifier
Operating system process identifier
Operating system process username. Any two-task user coming across the network has "-T" appended to the username.
Process serial number
Operating system terminal identifier
Program in progress
Trace file identifier
1 for a background process; NULL for a normal process
Address of latch the process is waiting for; NULL if none
Address of the latch the process is spinning on; NULL if none
PGA memory currently used by the process
PGA memory currently allocated by the process (including free PGA memory not yet released to the operating system by the server process)