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 |
|
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