Search code examples
sqloracle-databasesessionoracle9i

How do I find the high water mark (for sessions) on Oracle 9i


How can I find the high water mark (the historical maximum number of concurrent users) in an oracle database (9i).


Solution

  • This should do the trick:

    SELECT sessions_highwater FROM v$license;