Re: How to find out current users in Oracle 7.3

From: Ivan Boesing <boesing_at_geocities.com>
Date: 1997/10/03
Message-ID: <01bccf6b$29ad3a00$46013396@ivan.tre-rs.gov.br>#1/1

Try this:

select osuser,username
from v$session
where username IS NOT Null AND
status NOT IN ('KILLED');

Good Look,  

---

Ivan Boesing
boesing_at_geocities.com

---

Wolfgang Hann <W.Hann_at_netway.at> escreveu no artigo <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