How to find a high water sign (for sessions) on Oracle 9i

Question

How to find shortcut with high water (historical maximum number of simultaneous users) in oracle database (9i) .

+4

Bibd Aug 11 '08 at 19:53

2 answers

 select max_utilization from v$resource_limit where resource_name = 'sessions';

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

+1

JosephStyons Aug 11 '08 at 20:09

ninesided · Accepted Answer · 2008-08-11T20:05:44+0000

This should do the trick:

SELECT sessions_highwater FROM v$license;