Hello,
I'm trying to understand the meaning of gv$lock view columns.
from the Oracle Documentation the columns ID1 and ID2 are depended from the lock type.
so i created a table and I did a simple Updates from two different sessions without commit.
this is the result of gv$lock:
| INST_ID | ADDR | KADDR | SID | TYPE | ID1 | ID2 | LMODE | REQUEST | CTIME | BLOCK |
| 2 | 00000000B1910FB0 | 00000000B1911028 | 22 | TX | 7340043 | 74177 | 6 | 0 | 173 | 2 |
| 2 | 00002B15C9E3C378 | 00002B15C9E3C3D8 | 22 | TM | 637280 | 0 | 3 | 0 | 173 | 2 |
| 1 | 00002AE5366D93D0 | 00002AE5366D9430 | 135 | TM | 637280 | 0 | 3 | 0 | 27 | 2 |
| 1 | 00000000B7D1FC80 | 00000000B7D1FCD8 | 135 | TX | 7340043 | 74177 | 0 | 6 | 26 | 0 |
checking the values, from the TM lock type I can get the ID1 value which on this lock type clearly represents OBJEC_ID, this can be seen from DBA_OBJECTS.
the ID2 on TX Lock type seems to represent the the ITL Slot of the transaction. but i just can't understand what is the ID1 in TX lock type. I can't find it in Transactions or undo segments views. where it gets the ID1's 7340043 value from?
also, if the ID1 and ID2 values are depended on the lock type than how come there is no dictionary in the documentation of the possible values and their source\meanings?