Difference between revisions of "Adrci"
From dbawiki
(Created page with "===adrci=== A useful way to keep the purging of trace files under control.<br /> With an Oracle database environment setup, type: <pre> adrci </pre> To get out, type: <pre> ad...") |
|||
| Line 27: | Line 27: | ||
</pre> | </pre> | ||
This deletes all trace files older than 1 day (note the age parameter is minutes, not hours).<br /> | This deletes all trace files older than 1 day (note the age parameter is minutes, not hours).<br /> | ||
| + | ===Use command line interface from shell | ||
| + | <pre> | ||
| + | adrci exec="show homes" | ||
| + | adrci exec="set home diag/tnslsnr/ravjde01/listener_ravjde1;show control" | ||
| + | adrci exec="set home diag/tnslsnr/ravjde01/listener_ravjde1;set control (shortp_policy=360,longp_policy=720);purge;show control" | ||
| + | </pre> | ||
Revision as of 13:17, 15 November 2013
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).
===Use command line interface from shell
adrci exec="show homes" adrci exec="set home diag/tnslsnr/ravjde01/listener_ravjde1;show control" adrci exec="set home diag/tnslsnr/ravjde01/listener_ravjde1;set control (shortp_policy=360,longp_policy=720);purge;show control"
