How purge old trace and dump files
Starting from release Oracle 11g was indroduced a new feature which allows: 1. Viewing the alert.log 2. The relation between incident & problem 3. Creation of Packages & ZIP files to send to Oracle Support 4. Purging old diagnostic files This post we’ll be focusing on purging the old diagnostic files. There is now a special command line utility dedicated for that purpose called adrci (Automatic Diagnostic Repository Command Interpreter). – Use the following command to list ADR homes: ADRCI> show homes Diag/rdbms/orcldb/ORCLDB1 – Check the current retention policy: ADRCI> show control LONGP_POLICY is set to 365 days by default...