Thank you for visiting Spatial DBA - Oracle and ArcSDE.
Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
===================================================================
Property
|
Description
|
Parameter type
|
Integer
|
Default value
| 0 |
Modifiable
| ALTER SYSTEM |
Range of values
|
0 to value of
LICENSE_MAX_SESSIONS parameter |
Basic
|
No
|
Real Application Clusters
|
Multiple instances can have different values.
|
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").Note:
1. Related:
Parameter: LICENSE_MAX_SESSIONS
Oracle writes a message in the ALERT file for each new connection.
Eg:
"License warning limit (5) exceeded"
2. Query for the current value of the parameter
select name, value, isdefault, isses_modifiable, issys_modifiable,
isinstance_modifiable, isdeprecated, description
from v$parameter
where upper(name) = ‘LICENSE_SESSIONS_WARNING’;
NAME
|
VALUE
|
IS
DEFAULT
|
ISSES_
MODIFIABLE
|
ISSYS_
MODIFIABLE
|
ISINSTANCE_
MODIFIABLE
|
IS
DEPRECATED
|
DESCRIPTION
|
license_sessions_warning
|
0
|
TRUE
|
FALSE
|
IMMEDIATE
|
TRUE
|
FALSE
|
warning level for number of
non-system user sessions
|
