 |
|
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.
 |
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. |
|
