Oracle 11g diagnostic_dest Parameter Tips

Oracle11g Tips by Burleson Consulting

These are work in progress excerpts from the book "Oracle 11g New Features" authored by John Garmany, with Oracle ACE's Steve Karam, Lutz Hartmann, V.J. Jain and Brian Carr.

Starting in Oracle11g we not longer have many of the original OFA file system structures and we see that the ancient dump destination init.ora parms (core_dump_dest, background_dump_dest, user_dump_dest) are placed by a single diagnostic_dest parameter, the place to go when Oracle wants to take a dump.

You can use the new initialization parameter diagnostic_dest to specify an alternative location for the diag directory contents.

For details on using diagnostic_dest, see our notes on Oracle 11g directory location changes.

diagnostic_dest and ADR

The new ADR (Automatic Diagnostic Repository) and Incident Packaging System, all designed to allow quick access to alert and diagnostic information.

The new $ADR_HOME directory is located by default at $ORACLE_BASE/diag, with the directories for each instance at $ORACLE_HOME/diag/$ORACLE_SID, at the same level as the traditional bdump, udump and cdump directories and the initialization parameters background_dump_dest and user_dump_dest are deprecated in 11g.

Rampant author Laurent Schneider has some additional insight into creating an Oracle Automatic Diagnostic Repository (ADR).

If you like Oracle tuning, you may enjoy my new book "Oracle Tuning: The Definitive Reference", over 900 pages of BC's favorite tuning tips & scripts.

You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

��