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
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
No comments :
Write comments