How to check session count per user in Oracle

Quick tally of connected sessions grouped by username. Useful for spotting connection pool leaks or checking whether an app is holding more sessions than expected.

SELECT COUNT(*) AS connections, username
FROM   v$session
GROUP BY username
ORDER BY connections DESC;