Re: 9.2.0.4 - RHEL3

Tom <tomNOSPAM_at_teameazyriders.com> wrote in news:1121358937.32529.0_at_spandrell.news.uk.clara.net:

> Hi
>
> I currently have a script running made up of
>
> select username, count(*) from v$session group by username
>
> that spools to a text file to give me number of connected users at any
> one time. How can i see how many sessions are also active at that time?
>

select count(*) from v$session ; Received on Thu Jul 14 2005 - 21:03:21 CDT