sessions numbers

RHEL 3
9.2.0.4

I currently log into a file the number of connected users at a given time with

select username, count(*) from v$session group by username;

Is there anyway to include session numbers into this also? eg each user has x sessions?

thanks! Received on Tue Jul 19 2005 - 05:28:55 CDT