How can I find the high water mark (the historical maximum number of concurrent users) in an oracle database (9i).
+2
A:
This should do the trick:
SELECT sessions_highwater FROM v$license;
ninesided
2008-08-11 20:05:44
A:
select max_utilization from v$resource_limit where resource_name = 'sessions';
A good overview of Oracle system views can be found here.
JosephStyons
2008-08-11 20:09:12
Doesn't this just tell me the maximum number of connections that I will allow on the database, not the maximum that it has achieved???
CodeSlave
2008-09-15 14:26:14