SNAPSHOT_ID |
✔ |
Oracle monitor: snapshot ID |
ORA_SNAPSHOT_ID |
NUMC |
10 |
* |
INST_ID |
✔ |
Oracle monitor: Instance ID |
ORA_INST_ID |
DEC |
22 |
|
ADDR |
✔ |
Oracle monitoring: ADDR |
ORA_ADDR |
RAW |
8 |
|
PID |
✔ |
Oracle monitoring: PID |
ORA_PID |
DEC |
22 |
|
SPID |
|
Oracle monitoring: Operating system process identifier |
ORA_SPID |
CHAR |
12 |
|
USERNAME |
|
Oracle monitoring: USERNAME: Oracle username |
ORA_USERNAME |
CHAR |
30 |
|
SERIAL |
|
Oracle monitoring: SERIAL#: Session serial number |
ORA_SERIAL |
DEC |
22 |
|
TERMINAL |
|
Oracle monitoring: MACHINE: Operating system machine name |
ORA_TERMINAL |
CHAR |
30 |
|
PROGRAM_OS |
|
Oracle monitoring: PROGRAM: Operating system program name |
ORA_PROGRAM |
CHAR |
48 |
|
TRACEID |
|
Oracle monitoring: Trace file identifier |
ORA_TRACEID |
CHAR |
255 |
|
BACKGROUND |
|
Oracle monitoring: Background/Normal process |
ORA_BACKGROUND |
CHAR |
1 |
|
LATCHWAIT |
|
Oracle monitoring: @ of latch the process is waiting for |
ORA_LATCHWAIT |
CHAR |
8 |
|
LATCHSPIN |
|
Oracle monitoring: @ of latch the process is spinning on |
ORA_LATCHSPIN |
CHAR |
8 |
|
PGA_USED_MEM |
|
Oracle monitoring: PGA memory currently used by the process |
ORA_PGA_USED_MEM |
DEC |
22 |
|
PGA_ALLOC_MEM |
|
Oracle monitoring: PGA memory allocated by the process |
ORA_PGA_ALLOC_MEM |
DEC |
22 |
|
PGA_FREEABLE_MEM |
|
Oracle monitoring: Allocated PGA memory which can be freed |
ORA_PGA_FREEABLE_MEM |
DEC |
22 |
|
PGA_MAX_MEM |
|
Oracle monitoring: Max PGA memory allocated by the process |
ORA_PGA_MAX_MEM |
DEC |
22 |
|