Re: session high_water_mark

On Aug 10, 9:15 am, joebaye..._at_yahoo.com wrote:
> 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.

using select * from v$licence, I got
SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT SESSIONS_HIGHWATER USERS_MAX

• ---------------- ---------------- ------------------

  ---

  0 0 68 68 0

 I got the answer as 68.

v$licence and v$resource_limit is not consistent. Which one is more accurate? Received on Fri Aug 10 2007 - 08:49:32 CDT