Posts

Showing posts with the label Purging trace and dump files with 11g ADRCI

Purging trace and dump files with 11g ADRCI

Purging trace and dump files with 11g ADRCI In previous versions of Oracle prior to 11g, we had to use our own housekeeping scripts to purge the udump, cdump and bdump directories. In Oracle 11g, we now have the ADR (Automatic Diagnostic Repository) which is defined by the diagnostic_dest parameter. So how are unwanted trace and core dump files cleaned out in 11g automatically? This is done by the MMON background process. There are two time attributes which are used to manage the retention of information in ADR. Both attributes correspond to a number of hours after which the MMON background process purges the expired ADR data. LONGP_POLICY (long term) defaults to 365 days and relates to things like Incidents and Health Monitor warnings. SHORTP_POLICY (short term) defaults to 30 days and relates to things like trace and core dump files The ADRCI command show control will show us what the current purge settings are as shown below. adrci> show control ADR Home = /u01/app/oracle/diag/...