I have an Oracle database on a VMWare image that seems to be slowly eating all my available disk space. I would like to know if there is a command or script that would perform some kind of clean up of temporary or log data? This is a development image so data loss isn't a big deal, but available space is huge!
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
To get you started, check:
I agree that the archive logs can be deleted when they are beyond a set period of time. Doing this solved a similar space issue for a database I maintain. However some thought about the "why" would be a good idea. If this is a development database and it is not performing the same way as production then you have an issue with your application stack.
1) Is production performing the same way but you have lots of disk space so you don't care? Or is this only on the development VM image? Just cleaning up log files solves the problem but not the root issue.
2) I have not noticed any differences for Oracle databases that have been virtualized.
3) Check the size of the .dbf files. Do they represent a significant portion of the space used? If so, then you may need to increase the VM disk size.