工作中需要根据Oracle某个transaction的ID查找其他的信息，如何获得transaction ID可能也是许多朋友的疑问，在存储加以说明，只需要调用一下过程就可以得到：dbms_transaction.LOCAL_TRANSACTION_ID

Example:

SQL> delete from isc_$clob;

203 rows deleted

SQL> select dbms_transaction.LOCAL_TRANSACTION_ID from dual;

LOCAL_TRANSACTION_ID
--------------------------------------------------------------------------------
10.3.501549