License High Water Mark in Alert Log

The message was originally intended to let you know the maximum number of users sessions were used between bounces so that you could check this against how many sessions you were licensed for.

[root@localhost ~]# cat /u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log |grep high
License high water mark = 169

You can query the V$LICENSE data dictionary view for the high water mark, it is a sessions_highwater column. Also, the current limits for all of the license settings, the current number of sessions, and the maximum number of concurrent sessions for the instance can be queried in V$LICENSE.

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release Production on Sun May 27 07:56:03 2018

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release - 64bit Production

SQL> select sessions_max s_max, sessions_warning s_warning, sessions_current s_current, sessions_highwater s_high, users_max
from v$license;

---------  ----------  ----------    ----------  ----------
0              0         26            169          0

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.