Re: number of users using oracle

From: Cong TANG <lai-tang_at_mycity.at>
Date: Wed, 01 Dec 1999 20:41:51 +0100
Message-ID: <384579FF.A07E81ED@mycity.at>

Please try:

1) Number of sessions to the database
select count(*) from v$session
where username is not null;

2) Number of machines connected to the database (a good estimate for the number of users using oracle)
select distinct machine from v$session
where username is not null;

fumi wrote:

Nicolas Bronke <newsgroup@trinity.de> wrote in message news:3843ecbd_1@news2.prserv.net...
>
> > You can give this simple command and get the No. of oracle sessions -
> about
> > 8/10 sessions and rest will be No. of users login in your system.
> > select  count(*) from v$session;
> > The  Result  - 8 (oracle background processes) = users in your system
> >
> This won't work. In my case I would reveive that -1 one user is connected.

Try this:

select sessions_current from v$license;

Received on Wed Dec 01 1999 - 13:41:51 CST