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 12.2.0.1.0 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 12.2.0.1.0 - 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; S_MAX S_WARNING S_CURRENT S_HIGH USERS_MAX --------- ---------- ---------- ---------- ---------- 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: https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
