License_max_sessions,license_max_users,license_sessions_warning

今天测试环境碰到session maximum exceeded, DBA logon allow提示.小记下三个相关参数

 

LICENSE_MAX_SESSIONS
LICENSE_MAX_SESSIONS specifies the maximum number of concurrent user sessions
allowed. When this limit 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.
Property Description
Parameter type Integer
Default value 0
Modifiable ALTER SYSTEM
Range of values 0 to number of session licenses
Basic No
Real Application Clusters
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.

LICENSE_MAX_SESSIONS specifies the maximum number of concurrent user sessions
allowed. When this limit 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" on page 1-68).
Do not enable both concurrent usage licensing and user licensing. Set either
LICENSE_MAX_SESSIONS or LICENSE_MAX_USERS to zero.

LICENSE_MAX_USERS
LICENSE_MAX_USERS specifies the maximum number of users you can create in the
database. When you reach this limit, you cannot create more users. You can, however,
increase the limit.
Do not enable both concurrent usage (session) licensing and user licensing. Set either
LICENSE_MAX_SESSIONS or LICENSE_MAX_USERS to zero.
PropertyDescription
Parameter type Integer
Default value 0
Modifiable ALTER SYSTEM
Range of values 0 to number of user licenses
Basic No
Real Application
Clusters
Oracle recommends that multiple instances have the same value.

 

LICENSE_SESSIONS_WARNING
LICENSE_SESSIONS_WARNING specifies a warning limit on the number of concurrent
user sessions. When this limit is reached, additional users can connect, but Oracle
writes a message in the alert file 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" on page 1-67).