Re: How to find out current users in Oracle 7.3

You can also just check while in the Motif Server Manager (Unix box?), the security-users screen tells you whether each user is logged in or not.

Sanlam wrote:
>
> 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