patternMinor
Oracle clean up
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
noarchivelogif PITR is not required)
- whether the datafiles/tempfiles in your tablespaces have
autoextendenabled and an unlimited maximum size.
$ORACLE_HOME/network/logfor the listener log
- the various
_dump_destdirectories for tracefiles and the alert log
Context
StackExchange Database Administrators Q#4727, answer score: 8
Revisions (0)
No revisions yet.