Re: cron job at linux to remove trace and audit files

  • From: "Mladen Gogala" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "mgogala@xxxxxxxxx" for DMARC)
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 09 Jun 2015 09:16:32 -0400

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: @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

--
//www.freelists.org/webpage/oracle-l


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 06-2015