Re: number of users using oracle

From: Nisar Tareen <ntareen_at_attcanada.net>
Date: Tue, 30 Nov 1999 02:39:32 GMT
Message-ID: <ENG04.5007$fy1.506@tundra.ops.attcanada.net>

I don't know that this is the answer you are interested in to know,

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

Nisar Tareen

<kaprino_at_my-deja.com> wrote in message news:81v57h$cqt$1_at_nnrp1.deja.com...
> Just wanted to know if there was a simple command in oracle to see how
> many users are accessing or logged into the database, similiar to
> sybase's sp_who command. If not, how or what would I have to do to
> find out?
>
> Thanks
>
> Kaprino
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Nov 29 1999 - 20:39:32 CST