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).

wolφi
Pertanyaan edit 6 Juni 2018 в 7:53
Pemrograman
sql oracle session oracle9i
11 Agustus 2008 в 7:53
13 tayangan
Larutan

This should do the trick:

SELECT sessions_highwater FROM v$license;
Komentar (0)
 
select max_utilization from v$resource_limit where resource_name = 'sessions';

A good overview of Oracle system views can be found here.

JosephStyons
Jawaban edit 26 Agustus 2008 в 3:42
Komentar (0)