Below script can be used to find the active transactions in the oracle database.