View the current license status
SQL> show parameter license;NAME TYPE VALUE------------------------------------ ----------- ------------------------------license_max_sessions integer 0license_max_users integer 0license_sessions_warning integer 0
View the maximum number of concurrent connections in Oracle, but view the V $ license view.
V $ license View:
It records the maximum concurrency of Oracle and the number of connections of the current user,
The official documents are described as follows:
This view contains information about license limits.
Column |
Datatype |
Description |
SESSIONS_MAX
|
NUMBER
|
Maximum number of concurrent user sessions allowed for the instance |
SESSIONS_WARNING
|
NUMBER
|
Warning limit for concurrent user sessions for the instance |
SESSIONS_CURRENT
|
NUMBER
|
Current number of concurrent user sessions |
SESSIONS_HIGHWATER
|
NUMBER
|
Highest number of concurrent user sessions since the instance started |
USERS_MAX
|
NUMBER
|
Maximum number of named users allowed for the database |
In fact, the sessions_current in this attempt is equivalent to select count (*) from V $ session where type = 'user'
Show parameter license_max_sessions // you can view the maximum number of concurrent threads. If it is 0, the default value is unlimited.
As described in the initialization file, the initialization file is the main