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!
Oracle clean up
oracle
Related Question
- Possible RMAN orphan files in backup directory
- Oracle 12 startup issue: disk full
- Allow refresh of lower environment from production when using a HSM
- Oracle 11.2.0.4: Basic info using RMAN for backups
- How to export a single schema from Oracle EE to Oracle XE
- Why doesn’t Oracle expdp create the dump file
- Oracle DB | Issue with agent and OMS connection
- Oracle: Decreasing PCTFREE on large table
Best Answer
To get you started, check:
noarchivelog
if PITR is not required)autoextend
enabled and an unlimited maximum size.$ORACLE_HOME/network/log
for the listener log_dump_dest
directories for tracefiles and the alert log