Oracle教程 2023-02-26

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

本站中文解释

BACKGROUND_DUMP_DEST参数设置了在Oracle出现故障情况下的转储文件的存储路径。本参数通常设置在 trace 文件，报告文件，警告日志，故障检测文件及调试日志等文件的存储路径。

设置方法：

1、首先检查你的存储路径，确保路径存在并且拥有足够的空间；

2、使用以下SQL命令设置BACKGROUND_DUMP_DEST参数：

ALTER SYSTEM SET BACKGROUND_DUMP_DEST = ‘path name’；

3、重启Oracle数据库：

SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP

注意：在设置任何系统参数时，应该考虑设置的有效性，对可能导致性能受损的参数，要尤其小心，并考虑备份当前的参数设置。

官方英文解释

BACKGROUND_DUMP_DEST specifies the pathname (directory or disc) where debugging trace files for the background processes (LGWR, DBWn, and so on) are written during Oracle operations.

Property	Description
Parameter type	String
Syntax	`BACKGROUND_DUMP_DEST = {` `pathname` `\|` `directory` `}`
Default value	Operating system-dependent
Modifiable	`ALTER SYSTEM`
Modifiable in a PDB	No
Range of values	Any valid local path, directory, or disk
Basic	No

Note:

The BACKGROUND_DUMP_DEST parameter is deprecated in Oracle Database 12c Release 1 (12.1.0.1).

An alert log in the directory specified by BACKGROUND_DUMP_DEST logs significant database events and messages. Anything that affects the database instance or global database is recorded here. The alert log is a normal text file. Its file name is operating system-dependent. For platforms that support multiple instances, it takes the form alert_sid.log, where sid is the system identifier. This file grows slowly, but without limit, so you might want to delete it periodically. You can delete the file even when the database is running.

Note:

This parameter is ignored by the diagnosability infrastructure introduced in Oracle Database 11g Release 1 (11.1), which places trace and core files in a location controlled by the DIAGNOSTIC_DEST initialization parameter.

本站中文解释

官方英文解释

相关推荐