Troubleshooting oracle transaction recovery ? (transaction recovery)

select state, undoblocksdone, undoblockstotal, undoblocksdone / undoblockstotal * 100 from gv$fast_start_transactions where state != 'RECOVERED';

If above query shows no progress then check if transaction really needs recovery.

If following query does not return any record there is no need for recovery (oracle 10g)

select * from x$ktuxe where ktuxesta = 'ACTIVE' and ktuxecfl like '%DEAD%'