Below script will display information about the distributed pending transactions in oracle.