Re: HighWater_Session

JimLim <member24937_at_dbforums.com> wrote in message news:<2570351.1046140976_at_dbforums.com>...
> The value of high_water session tracks the number of oracle users.
> Although it could be reset by re-starting the database,
>
> May I know is there other method of doing it?
>
> This is because restarting the database might affect alot of users.

Try looking at the v$session view, which is documented in the Oracle version# Reference Manual. The table contains an entry for every currently connected session.

HTH -- Mark D Powell -- Received on Tue Feb 25 2003 - 09:46:35 CST