Cheeky Cockatoo

Life Advice and Stories, Travel, Oracle Tech, Good Food and More

2pc.sql

Download Script

SELECT 
LOCAL_TRAN_ID, GLOBAL_TRAN_ID, STATE, MIXED, HOST, COMMIT#
FROM
DBA_2PC_PENDING
WHERE
LOCAL_TRAN_ID = '&1';
SELECT LOCAL_TRAN_ID, IN_OUT, DATABASE, INTERFACE
FROM DBA_2PC_NEIGHBORS;