Oracle License High Water Mark Query
kirkladbDec 16 2012 — edited Dec 16 2012I have a few Named User Plus licenses for Oracle Enterprise Edition. Is there a way to tell how many licenses I have ever used in order to stay in compliance with my Oracle licensing agreement? I have checked the alert log file and I have seen License high water mark = 114 and then 107 but the database hasn't been bounced in over an year. Is there a query I can run to see how many licenses have been used. I ran the following:
SQL> SELECT sessions_max s_max,
sessions_warning s_warning,
sessions_current s_current,
sessions_highwater s_high,
users_max
FROM v$license;
2 3 4 5 6
S_MAX S_WARNING S_CURRENT S_HIGH USERS_MAX
---------- ---------- ---------- ---------- ----------
0 0 29 128 0
Not sure if that is giving me what I need. Any help would be greatly appreciated. In case the above results are hard to read s_current = 29, s_high = 128 and all other fields are zero(0)
Edited by: kirkladb on Dec 16, 2012 6:02 PM