How to check oracle license, current sessions and maximum sessions?

Three ways to check Oracle License details:-

1.V$LICENSE:- Displays information about license limits.
This view allows you to query the current limits of all of the license settings, the current number of sessions, and the maximum number of concurrent sessions for the instance.

select sessions_max max_sessions,
   sessions_warning warning_sessions,
   sessions_current current_sessions,
   sessions_highwater hw_sessions,
   users_max max_users
   from v$license;

2. V$PARAMETER

column name format a25;
column value format a5;
column description format a45;
select name,value,description from v$parameter where name like 'license%';


3. PARAMETER LICENSE

show parameter license;

Below is the output of given SQL Scripts:-



No comments :
Write comments