Oracle 参数 LICENSE_MAX_SESSIONS 官方解释，作用，如何配置最优化建议
本站中文解释
：
LICENSE_MAX_SESSIONS参数是一个数据库实例的一个参数，用来限制数据库实例的最大会话用户数。它必须在安装前就被设置，在安装过程中不接受更改。该参数的默认值为100个会话用户，但用户可以更改此值以满足其系统负载要求。
要正确设置LICENSE_MAX_SESSIONS参数，首先应查明系统将面临多少的最大的并发会话数。一般来说，这是由系统的业务负载和用户数来决定的。比如，如果系统预计有500名用户，那么就需要配置超过500个会话用户的LICENSE_MAX_SESSIONS参数。
最后，应检查服务器的内存大小是否需要优化，以便确保系统可以正常运行，不受影响。
官方英文解释
LICENSE_MAX_SESSIONS specifies the maximum number of concurrent user sessions allowed.
| Property | Description |
|---|---|
|
Parameter type |
Integer |
|
Default value |
|
|
Modifiable |
|
|
Modifiable in a PDB |
No |
|
Range of values |
0 to number of session licenses |
|
Basic |
No |
|
Oracle RAC |
Multiple instances can have different values, but the total for all instances mounting a database should be less than or equal to the total number of sessions licensed for that database. |
Note:
Oracle no longer offers licensing by the number of concurrent sessions. Therefore the LICENSE_MAX_SESSIONS and LICENSE_SESSIONS_WARNING initialization parameters have been deprecated.
When the limit specified by LICENSE_MAX_SESSIONS is reached, only users with the RESTRICTED SESSION privilege can connect to the database. Users who are not able to connect receive a warning message indicating that the system has reached maximum capacity.
A zero value indicates that concurrent usage (session) licensing is not enforced. If you set this parameter to a nonzero number, you might also want to set LICENSE_SESSIONS_WARNING (see “LICENSE_SESSIONS_WARNING”).
Do not enable both concurrent usage licensing and user licensing. Set either LICENSE_MAX_SESSIONS or LICENSE_MAX_USERS to zero.
See Also:
Oracle Database
Administrator’s Guide for more information about this parameter
