jeudi 25 avril 2013

Oracle : counting the number of sessions used for each client

Retrieving the number of sessions used for each client :

select 

           username, osuser, machine, count(*) as sessions
from 

           v$session
group 

           by username, osuser, machine
order 

           by sessions desc

Aucun commentaire:

Categories