Our undo table space UNDOTBS01.DBF ahs recently jumped to 2.6 GB of data after the machine crashed repeatedly. Is there any way of cleaning up what is held in the file or should I be leaving it alone?
I do need the space its taking up as the disk is now almost full (56k free) and Oracle is running extremely slowly.