HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Oracle clean up

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
oraclecleanstackoverflow

Problem

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!

Solution

To get you started, check:

  • the archivelog destination directory (consider switching to noarchivelog if PITR is not required)



  • whether the datafiles/tempfiles in your tablespaces have autoextend enabled and an unlimited maximum size.



  • $ORACLE_HOME/network/log for the listener log



  • the various _dump_dest directories for tracefiles and the alert log

Context

StackExchange Database Administrators Q#4727, answer score: 8

Revisions (0)

No revisions yet.