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
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment