9.2.0.4 - RHEL3

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?

thanks Received on Thu Jul 14 2005 - 11:37:38 CDT