Oracle教程 2023-02-26

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

本站中文解释

MAX_AUTH_SERVERS 参数指定一个连接到Oracle服务器的客户端最大可认证服务器的数量。默认情况下，它的值被设为25。

设置MAX_AUTH_SERVERS参数的正确方法是，先在SQL*Plus环境中连接到数据库，然后使用 ALTER SYSTEM 语句将其设置为指定的值:

alter system set MAX_AUTH_SERVERS=50 scope=SPFILE;

之后重启Oracle实例，以使更改生效：
shutdown immediate
startup

这样就可以将 MAX_AUTH_SERVERS 参数的值设置为指定的值，以实现与Oracle连接的客户端的最多可认证服务器数量的增加。

官方英文解释

MAX_AUTH_SERVERS specifies the maximum number of authentication servers in the authentication pool. This pool authenticates user connections when client applications connect to Database Resident Connection Pooling (DRCP).

Property	Description
Parameter type	Integer
Default value	`25`
Modifiable	`ALTER SYSTEM`
Modifiable in a PDB	Yes, according to the following guidelines: When the `ENABLE_PER_PDB_DRCP` initialization parameter is set to `true`, `MAX_AUTH_SERVERS` can be modified only at the PDB level; it cannot be modified for the CDB root. When the `ENABLE_PER_PDB_DRCP` initialization parameter is set to `false`, `MAX_AUTH_SERVERS` can be modified only for the CDB root; it cannot be modified at the PDB level.
Range of values	Minimum: `MIN_AUTH_SERVERS` or `1`, whichever is the greater value Maximum: operating system-dependent
Basic	No
Oracle RAC	Different instances can use different values.

The value of this parameter must be greater than or equal to the value of the MIN_AUTH_SERVERS initialization parameter, which specifies the minimum number of authentication servers in the authentication pool. The exception is when MIN_AUTH_SERVERS = 0. In this case, the value of MAX_AUTH_SERVERS must be greater than or equal to 1.

Note:

This parameter is available starting with Oracle Database release 19c, version 19.10.

本站中文解释

官方英文解释

相关推荐