Is there a way to manually clear UndoTablespace.
For our Prod DB we take daily backup using Data Pump. Schema size is around 120GB. Backup takes more than 12hrs to complete. We noticed that whenever we restart the DB and then run the backup it complete merely in 1.5 or 2hrs.
I suspect it might be due to uncommitted transactions which might be there in undotablespace and after restart it gets clear, which results in speed up the backup.
Could anyone please let me know what could be causing the issue.