Hello,
This might be an easy one but I am feeling a little dense and would appreciate some help.
A query on V$TRANSACTION shows XID, XIDUSN,XIDSLOT,XIDSQN. My understanding is XID is of type RAW and XIDUSN,XIDSLOT,XIDSQN are derived from XID.
But How do I map them ?
For e.g.
select xid, xidusn, xidslot, xidsqn from v$transaction ;
XID XIDUSN XIDSLOT XIDSQN
---------------- --------------- --------------- ---------------
2700190004620300 39 25 221700
SQL> select to_char(39, 'XX') from dual ;
TO_
---
27
SQL> select to_char(25, 'XX') from dual ;
TO_
---
19
SQL> select to_char(221700, 'XXXXXX') from dual ;
TO_CHAR
-------
36204
Thanks in advance.