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.

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.

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.