Re: How to find out current users in Oracle 7.3

Hi

You can query the v$session view as user SYS or SYSTEM. This will give you the list of users currently logged on.

You can also check your ALERT.LOG to get the HIGHWATER mark. This will give you the maximum sessions logged on at one time.

Cheers
akader_at_health.sanlam.co.za

Wolfgang Hann <W.Hann_at_netway.at> wrote in article <01bccf3a$b376ee60$0201030a_at_ENTWICKLUNG.NETWAY.AT>...
> I have searched in a lot of manuals to find out
> a simple question, but i might be blind - i can´t find it.
>
> How can i find out which users are connected to Oracle?
> I need this to count the users, so the number of all
> connected ones would be enough.
>
> Thanks
>
> Wolfgang Hann
>
>
Received on Fri Oct 03 1997 - 00:00:00 CDT