connection between global and local transaction

Hello,

In principle it is very simple what we want - but in fact it mightn't be so easy to get the local transaction id back to application.

For our database lock analysis we would need a connection between the Global Transaction ID : XID and the local transaction which one can see in v$transaction table (xid_usn, xid_slot, xid_sqn).

We can not find any view or table in the database which is showing this relation.

Another solution would be to have an OCI call which will give us as return values the xid_usn, xid_slot and xid_sqn during execution of the global transaction. As we know within our application the global transaction id, then it would be possible to make a connection between global and local transaction ID.