IANAL_VISTA wrote:
> 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 ;
Well yes and no. Depends on how the OP defines sessions. Some rows in
v_$session are PMON, SMON, etc. Some may be dead and still rolling back
uncommitted transactions. The OP needs to more clearly define the
requirement.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sat Jul 16 2005 - 09:53:42 CDT
