Maximum Oracle concurrency & amp; License

View the current License status

SQL> show parameter license;
NAME TYPE VALUE
-----------------------------------------------------------------------------
License_max_sessions integer 0
License_max_users integer 0
License_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