I am trying to figure out how to get a count of the number of open sessions on our Oracle database. I have the sample Oracle SQL script running which grabs the up time, so I am at least able to connect to Oracle. But, trying to get the script to get the Open session is not working. What my Oracle DBA sent me to get the count and other info is.
select sid, serial#, username , schemaname , osuser from v$session order by schemaname /
Anyone know how to translate that into a script to get the count of sessions?