Oracle 参数 LICENSE_SESSIONS_WARNING 官方解释，作用，如何配置最优化建议
本站中文解释
LICENSE_SESSIONS_WARNING参数控制警告消息的阈值，当活动会话数超过警告消息阈值时，管理员会收到一个警告消息，要求检查Oracle数据库中的活动会话数。
LICENSE_SESSIONS_WARNING参数的可能值范围从0到无穷大，但它的默认值为0，如果值为0，则管理员将不会收到警告消息，即使在Oracle数据库中的活动会话超过阈值。
正确设置LICENSE_SESSIONS_WARNING参数的方法是，根据数据库保持活动会话的运行模式，确定一个可行的警告阈值，并根据警告阈值来设置所需的参数值。例如，如果警告阈值为100，则参数值应设置为100，以触发警告消息。
官方英文解释
LICENSE_SESSIONS_WARNING specifies a warning limit on the number of concurrent user sessions.
| Property | Description |
|---|---|
|
Parameter type |
Integer |
|
Default value |
|
|
Modifiable |
|
|
Modifiable in a PDB |
No |
|
Range of values |
0 to value of |
|
Basic |
No |
|
Oracle RAC |
Multiple instances can have different values. |
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 this limit specified by LICENSE_SESSIONS_WARNING is reached, additional users can connect, but Oracle writes a message in the alert log for each new connection. Users with RESTRICTED SESSION privilege who connect after the limit is reached receive a warning message stating that the system is nearing its maximum capacity.
If this parameter is set to zero, no warning is given as you approach the concurrent usage (session) limit. If you set this parameter to a nonzero number, you should also set LICENSE_MAX_SESSIONS (see “LICENSE_MAX_SESSIONS”).
See Also:
-
Oracle Database
Administrator’s Guide for more information on setting this parameter
