How find how much number of sessions for each terminal, Just execute following statement :
SELECT RPAD(terminal,15,'-')' ('count(sid)')' AS "Terminal"
FROM v$session
WHERE terminal IS NOT NULL
GROUP BY TERMINAL
ORDER BY COUNT(sid) DESC
Thursday, October 23, 2008
Subscribe to:
Posts (Atom)