Oracle clean up

oracle

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!

Best Answer

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