session high_water

From: <joebayerii_at_yahoo.com>
Date: Fri, 10 Aug 2007 06:15:14 -0700
Message-ID: <1186751714.307735.176470@i13g2000prf.googlegroups.com>

I need to get a session_connected high water mark on my 9208 database.

Using

select RESOURCE_NAME, CURRENT_UTILIZATION, MAX_UTILIZATION, INITIAL_ALLOCATION from v$resource_limit where resource_name='sessions'

I got the answer as 79

using

SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT SESSIONS_HIGHWATER USERS_MAX
------------ ---------------- ---------------- ------------------

           0                0               68
68          0

I got the answer as 68.

What is more accurate?

Thanks for your help. Received on Fri Aug 10 2007 - 08:15:14 CDT

session high_water_mark