Oracle 参数 DIAGNOSTIC_DEST 官方解释,作用,如何配置最优化建议

本站中文解释

DIAGNOSTIC_DEST参数控制Oracle数据库中的历史数据和诊断跟踪文件存储位置。DIAGNOSTIC_DEST参数的值必须是一个有效的操作系统的文件系统路径或指向一个有效的操作系统的磁盘分卷的字符串,用作通过诊断和统计收集来收集文件的目录。

正确设置:
1、确保DIAGNOSTIC_DEST实际存在,并有足够空间以容纳诊断文件和历史文件。
2、使用本地文件系统来存储数据库日志文件,以提高性能。
3、检查磁盘是否满,以避免溢出和性能下降。
4、将此目录的所有权指定为正确的用户和组。
5、设置定期清除功能,以定期清除此目录中的日志文件。

官方英文解释

As of Oracle Database 11g Release 1 (11.1), the diagnostics for each database instance are located in a dedicated directory that is specified by the DIAGNOSTIC_DEST initialization parameter.

Property Description

Parameter type

String

Syntax

DIAGNOSTIC_DEST = { pathname | directory }

Default value

Derived from the value of the $ORACLE_BASE environment variable. If $ORACLE_BASE is not set, then derived from ORACLE_BASE as set by the Oracle Universal Installer. If ORACLE_BASE is not set, then $ORACLE_HOME/rdbms/log is used.

Modifiable

ALTER SYSTEM

Modifiable in a PDB

No

Basic

No

Oracle RAC

This parameter can be set on each instance. Oracle recommends that each instance in a cluster specify a DIAGNOSTIC_DEST directory location that is located on shared disk and that the same value for DIAGNOSTIC_DEST be specified for each instance.

The structure of the directory specified by DIAGNOSTIC_DEST is as follows:

<diagnostic_dest>/diag/rdbms/<dbname>/<instname>

This location is known as the Automatic Diagnostic Repository (ADR) Home. For example, if the database name is proddb and the instance name is proddb1, the ADR home directory would be <diagnostic_dest>/diag/rdbms/proddb/proddb1.

The following files are located under the ADR home directory:

  • Trace files – located in subdirectory <adr-home>/trace

  • Alert logs – located in subdirectory <adr-home>/alert. In addition, the alert.log file is now in XML format, which conforms to the Oracle ARB logging standard.

  • Core files – located in the subdirectory <adr-home>/cdump

  • Incident files – the occurrence of each serious error (for example, ORA-600, ORA-1578, ORA-7445) causes an incident to be created. Each incident is assigned an ID and dumping for each incident (error stack, call stack, block dumps, and so on) is stored in its own file, separated from process trace files. Incident dump files are located in <adr-home>/incident/<incdir#>. You can find the incident dump file location inside the process trace file.

See Also:

Oracle Automatic Storage
Management Administrator’s Guide
for an example of the diagnostic directory for an Oracle ASM instance


数据运维技术 » Oracle 参数 DIAGNOSTIC_DEST 官方解释,作用,如何配置最优化建议