Contando sesiones de Oracle 10g

SELECT COUNT(*) FROM v$session WHERE USERNAME='pepito';
SELECT COUNT(*) FROM v$session WHERE SCHEMANAME='juanito';