Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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!

share|improve this question

2 Answers 2

up vote 7 down vote accepted

To get you started, check:

  1. the archivelog destination directory (consider switching to noarchivelog if PITR is not required)
  2. whether the datafiles/tempfiles in your tablespaces have autoextend enabled and an unlimited maximum size.
  3. $ORACLE_HOME/network/log for the listener log
  4. the various _dump_dest directories for tracefiles and the alert log
share|improve this answer
    
I'll check, thank you for the information thus far. –  Mondain Aug 17 '11 at 15:45
1  
This link was helpful when setting up noarchivelog: myadmin.wordpress.com/2007/02/25/… –  Mondain Aug 17 '11 at 16:19
1  
@Mondain: doesn't it just list the same steps in the Oracle Docs I linked to? (minus the "Back up the database" step!) –  Jack Douglas Aug 17 '11 at 16:23
    
Also check $ORACLE_HOME/network/log for the listener log, and the various _dump_dest directories for tracefiles - these can get very big, very quickly. –  Gaius Aug 18 '11 at 22:07
    
@Gaius thanks, answer updated. The alert log can also get very big, but that usually happens slowly :) –  Jack Douglas Aug 18 '11 at 22:22

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.

share|improve this answer
    
+1 useful advice –  Jack Douglas Aug 17 '11 at 16:40
    
This is a dev vm image and I don't have access to prod. I'm part of a independent contract team. You've got good points but I also cannot increase the disk size. –  Mondain Aug 17 '11 at 16:44

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.