Hello stefan,Actually there is a database bug and huge trace files are
generated regularly. It is okay no problem about 1 hour.I used adrci utility
and let the period 1 hour for (SHORTP_POLICY - LONGP_POLICY )but unfortunately
it didn't work regularly !
adrci> show control
ADR Home =
/opt/oracle/base/diag/rdbms/cdsdb/cdsdb:*************************************************************************ADRID
SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME
LAST_AUTOPRG_TIME LAST_MANUPRG_TIME
ADRDIR_VERSION ADRSCHM_VERSION ADRSCHMV_SUMMARY
ADRALERT_VERSION CREATE_TIME-------------------- --------------------
-------------------- ----------------------------------------
----------------------------------------
---------------------------------------- --------------------
-------------------- -------------------- --------------------
----------------------------------------2399313524 1
1 2015-06-08 13:20:02.335494 +02:00 2015-06-08
21:31:31.572752 +02:00 2015-06-08 14:56:13.053753 +02:00 1
2 76 1
2014-08-04 15:01:07.070974 +03:001 rows fetched
adrci>
Also I preferred to use cron job , to remove *.aud regularly for their path at
database.Thanks
On Tuesday, June 9, 2015 11:28 AM, Stefan Koehler <contact@xxxxxxxx> wrote:
Hi Mostafa,
why every 5 minutes - is 1 hour also ok? Usually no need to setup a seperate
cronjob for that (or at least for all the trace files).
Just set the ADR retention policies (SHORTP_POLICY / LONGP_POLICY) accordingly.
For more details please check MOS ID #975448.1.
Best Regards
Stefan Koehler
Freelance Oracle performance consultant and researcher
Homepage: http://www.soocs.de
Twitter: @OracleSK
Mostafa Eletriby <dmarc-noreply@xxxxxxxxxxxxx> hat am 9. Juni 2015 um 11:17--
geschrieben:
Hello professionals,
Please I need to set a cron job task to remove all trace and audit files at
database 11g every 5 minutes , platform linux v5
I want to know all the steps needed in order to run successfully because it
didn't work with me.
Please find below the steps performed.
Thanks
[root@Abohamad trace]# cat /etc/crontab
SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=root
HOME=/
# run-parts
01 * * * * root run-parts /etc/cron.hourly
02 4 * * * root run-parts /etc/cron.daily
22 4 * * 0 root run-parts /etc/cron.weekly
42 4 1 * * root run-parts /etc/cron.monthly
***********************************
00,05,10,15,20,25,30,35,40,45,50,55 * * * * root rm -rf
/opt/oracle/base/diag/rdbms/cdsdb/cdsdb/trace/*.trc & rm -rf
/opt/oracle/base/diag/rdbms/cdsdb/cdsdb/trace/cdmp* & rm -rf
/opt/oracle/base/diag/rdbms/cdsdb/cdsdb/trace/*.trm & rm -rf
/opt/oracle/base/admin/cdsdb/adump/*.aud
[root@Abohamad trace]#
[root@Abohamad sbin]# crontab -l
no crontab for root
[root@Abohamad sbin]#