Re: number of users using oracle

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 1 Dec 1999 15:12:23 GMT
Message-ID: <823dsn$rcb$3@news.seed.net.tw>

Nicolas Bronke <newsgroup_at_trinity.de> wrote in message news:3843ecbd_1_at_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 - 09:12:23 CST