This parameter specifies the location of the diagnostic destination
| Version | Type | Default | Session Modifiable |
System Modifiable |
| 11.1.0 | Integer | No | Immediate | |
| 11.2.0 | Integer | No | Immediate | |
| 12.1.0 | Integer | No | Immediate |
This parameter was introduced in Oracle 11.1
The parameter defaults to the value of the $ORACLE_BASE environment variable
For the database, the Automatic Diagnostic Repository (ADR) will be created below the directory specified by the diagnostic_dest parameter as follows:
<diagnostic_dest>/diag/rdbms/<dbname>/<instname>
Files located in the ADR include: