Re: How to find out current users in Oracle 7.3

Wolfgang Hann wrote:
>
> 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

Select * from v$license will give you all the current logins, (including yourself), no other information. V$session will give you everyone including the background processes.

-- 
Sheilah Scheurich
DBA

My opinions are my own and not that of my 
employer.

To respond via email, remove underscores.