License for the maximum number of Oracle concurrency

Check the current License SQLgt; showparameterlicense; NAMETYPEVALUE ---------------

Check the current License SQLgt; show parameter license; name type value ---------------

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.

ColumnDatatypeDescription

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