We use a hosted Oracle application and I know nothing about Oracle or any other database. We had a giant leap in disk usage and our hosting company couldnt determine the problem so I did some research myself and figured out we had the Oracle 10g bug 5387030 (Automatic tuning of undo_retention causes unusual extra space allocation). The hosting company verified we had the bug and we are currently having them implementing the fix.
They have already installed the patch on 2 out of 3 servers and I havent seen any drop in disk usage, how do we go about regaining the wasted space caused by this bug?
I read that you should bounce the server after applying the patch to regain the space, but since its like pulling teeth to get our hosting company to do anything, I wanted to verify this was the next step.
Thanks in advance,