Pending Transactions

Use the following queries to get pending transactions and after commit or rollback, purge then if it's necessary:

--Identifying transactions
select
'commit force '''local_tran_id'''; '
from
dba_2pc_pending;

--Purging
select
'exec dbms_transaction.purge_lost_db_entry('''local_tran_id'''); '
from
dba_2pc_pending
where
state='forced commit';