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

本站中文解释

DBNEST_PDB_FS_CONF参数控制多个Pluggable Database (PDB)的最大文件数,如果有多个PDB,可以在同一个CDB内相互分割。默认情况下,每个PDB可以有1000个数据文件,如果要增加PDB的文件数,可以使用DBNEST_PDB_FS_CONF参数。需要使用ALTER SYSTEM语句来增加该参数的值,比如下面这个例子:

ALTER SYSTEM SET DBMS_PDB_FS_CONF=’500′ SCOPE=SPFILE;

该设置将新增PDB的文件数上限提高到500个,如果要永久生效请使用persistent=TRUE,例如:

ALTER SYSTEM SET DBMS_PDB_FS_CONF=’500′ SCOPE=SPFILE PERSISTENT=TRUE;

建议永久生效,以便在实例重启时仍能生效。完成设置后,按照惯例,需要重启实例来使更改生效。

官方英文解释

DBNEST_PDB_FS_CONF specifies the dbNest file system configuration file for a PDB.

Note:

This parameter is applicable only on Linux systems.

Property Description

Parameter type

String

Syntax

DBNEST_PDB_FS_CONF = 'pathname'

Default value

None

Modifiable

No

Modifiable in a PDB

No

Basic

No

Oracle RAC

Multiple instances can have different values.

A dbNest file system configuration file specifies directories to be mounted inside the nest for a PDB. These directories are mounted in addition to the default directories.

For pathname, specify the full operating system path for the file.

If you do not set this parameter, then only the default directories are mounted.

Note:

This parameter is available starting with Oracle Database 21c.

See Also:

Oracle Multitenant
Administrator’s Guide
for information on dbNest file system configuration files


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