Re: number of users using oracle

> 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 select count(username) from v$session. --
Regards
Nicolas Bronke Received on Tue Nov 30 1999 - 09:07:30 CST