Re: cron job at linux to remove trace and audit files
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Tue, 09 Jun 2015 09:16:32 -0400
Message-ID: <5576E730.9060706_at_yahoo.com>
On 06/09/2015 05:28 AM, Stefan Koehler 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: _at_OracleSK
>
>
That article lacks the vital information that the policy values are expressed in hours. So, to purge trace files and core dumps daily (a bit excessive, I admit), SHORTP_POLICY would need to be set to 24.
Date: Tue, 09 Jun 2015 09:16:32 -0400
Message-ID: <5576E730.9060706_at_yahoo.com>
On 06/09/2015 05:28 AM, Stefan Koehler 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: _at_OracleSK
>
>
That article lacks the vital information that the policy values are expressed in hours. So, to purge trace files and core dumps daily (a bit excessive, I admit), SHORTP_POLICY would need to be set to 24.
-- Mladen Gogala Oracle DBA http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 09 2015 - 15:16:32 CEST