How do I find the high water mark (for sessions) on Oracle 9i
11,004
Solution 1
This should do the trick:
SELECT sessions_highwater FROM v$license;
Solution 2
select max_utilization from v$resource_limit where resource_name = 'sessions';
A good overview of Oracle system views can be found here.
Comments
-
BIBD almost 2 years
How can I find the high water mark (the historical maximum number of concurrent users) in an oracle database (9i).