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

本站中文解释

参数

DB_CREATE_FILE_DEST参数是Oracle中的创建文件目标参数,它指定了一个目录,用于存放需要创建的物理文件,包括但不限于数据文件,控制文件,日志文件,等等。

正确设置DB_CREATE_FILE_DEST参数需要遵守以下几个原则:

1、创建文件目标要具有足够高的I/O性能;

2、DB_CREATE_FILE_DEST设置的不是可执行文件目录;

3、创建文件目标可以是一个raid卷;

4、创建文件目标的操作系统用户是Oracle安装用户;

5、DB_CREATE_FILE_DEST参数应定义为一个有效的操作系统目录,如:/u01/oradata。

官方英文解释

DB_CREATE_FILE_DEST specifies the default location for Oracle-managed datafiles.

Property Description

Parameter type

String

Syntax

DB_CREATE_FILE_DEST = directory | disk group

Default value

There is no default value.

Modifiable

ALTER SESSION, ALTER SYSTEM

Modifiable in a PDB

Yes

Basic

Yes

This location is also used as the default location for Oracle-managed control files and online redo logs if none of the DB_CREATE_ONLINE_LOG_DEST_n initialization parameters are specified.

If a file system directory is specified as the default location, then the directory must already exist; Oracle does not create it. The directory must have appropriate permissions that allow Oracle to create files in it. Oracle generates unique names for the files, and a file thus created is an Oracle Managed File.

See Also:

Oracle Database
Administrator’s Guide
for more information on setting this parameter and on Oracle Managed Files


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