Thursday, October 23, 2008

Finding number of sessions terminal whise

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