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 |
|
KADDR |
✔ |
Oracle monitoring: KADDR |
ORA_KADDR |
RAW |
8 |
|
SID |
|
Oracle monitoring: SID (Session) |
ORA_SID |
DEC |
22 |
|
TYPE |
|
Oracle Monitoring: Type of user or system lock |
ORA_TYPE |
CHAR |
2 |
|
ID1 |
|
Oracle monitoring: Lock identifier #1 (depends on type) |
ORA_ID1 |
DEC |
22 |
|
ID2 |
|
Oracle monitoring: Lock identifier #2 (depends on type) |
ORA_ID2 |
DEC |
22 |
|
LMODE |
|
Oracle monitoring: LMODE Lock mode in which the session hold |
ORA_LMODE |
DEC |
4 |
|
REQUEST |
|
Oracle monitoring: Lock mode in which the process requests |
ORA_REQUEST |
DEC |
22 |
|
CTIME |
|
Oracle monitoring: Time since current mode was granted |
ORA_CTIME |
DEC |
22 |
|
BLOCK |
|
Oracle monitoring: The lock is blocking another lock |
ORA_BLOCK |
DEC |
22 |
|