How can I find the high water mark (the historical maximum number of concurrent users) in an oracle database (9i).
This should do the trick:
SELECT sessions_highwater FROM v$license;