Adrci
From dbawiki
adrci
A useful way to keep the purging of trace files under control.
With an Oracle database environment setup, type:
adrci
To get out, type:
adrci> exit
To get help, type:
adrci> help
To see current setup, type:
adrci> show control
SHORTP_POLICY and LONGP_POLICY are number of hours to keep trace files and alert files respectively. These can be changed by typing:
set control (SHORTP_POLICY=240)
Trace files will now be deleted after 10 days.
If space is running low, you can manually delete trace files like this:
purge -age 3600 -type TRACE
This deletes all trace files older than 1 day (note the age parameter is minutes, not hours).
