...
| Note |
|---|
Use v$transaction on Non RAC systems instead of gv$transaction |
| Info |
|---|
If this above transaction does not return any rows, then look into v$session on target database to find the Transaction ID in columns MODULE and ACTION |
...
If uncommitted transactions happen on a frequent basis, please Contacting Contact Support
Please also see http://support.dbvisit.com/entries/24825508-Committing-uncommitted-transactions
...